QBasic & Borland Pascal & C

home *** CD-ROM | disk | FTP | other *** search
/ QBasic & Borland Pascal & C / Delphi5.iso / Runimage / Borland Shared / DATA / EMPLOYEE.GBK < prev next >
Unknown | 1999-08-11 | 71.0 KB
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

This file was not able to be converted.
This format is not currently supported by dexvert.
Confidence	Program	Detection	Match Type	Support
`10%`	dexvert	Degas High Resolution Picture (PI) `(image/degasHiPI)`	magic	Supported
`100%`	file	Atari DEGAS Elite bitmap 640 x 400 x 2, color palette 0404 0000 0004 0401 0000 ...	default (weak)
`99%`	file	data	default
`100%`	TrID	DEGAS hi-res bitmap	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 02 04 04 00 00 00 04 | 04 01 00 00 00 05 04 01 |........|........|
|00000010| 00 00 00 06 04 00 02 00 | 00 08 04 01 00 00 00 07 |........|........|
|00000020| 0c 65 6d 70 6c 6f 79 65 | 65 2e 67 64 62 01 18 53 |.employe|e.gdb..S|
|00000030| 61 74 20 4f 63 74 20 30 | 35 20 31 32 3a 32 31 3a |at Oct 0|5 12:21:|
|00000040| 32 32 20 31 39 39 36 00 | 0e 05 04 00 04 00 00 08 |22 1996.|........|
|00000050| 04 20 4e 00 00 01 0c 65 | 6d 70 6c 6f 79 65 65 2e |. N....e|mployee.|
|00000060| 67 64 62 00 01 00 02 01 | 09 46 49 52 53 54 4e 41 |gdb.....|.FIRSTNA|
|00000070| 4d 45 05 00 07 00 08 04 | 25 00 00 00 0a 04 0f 00 |ME......|%.......|
|00000080| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00000090| 0f 00 00 00 2a 04 00 00 | 00 00 2b 04 00 00 00 00 |....*...|..+.....|
|000000a0| 00 02 01 08 4c 41 53 54 | 4e 41 4d 45 05 00 07 00 |....LAST|NAME....|
|000000b0| 08 04 25 00 00 00 0a 04 | 14 00 00 00 09 04 00 00 |..%.....|........|
|000000c0| 00 00 0b 04 00 00 00 00 | 29 04 14 00 00 00 2a 04 |........|).....*.|
|000000d0| 00 00 00 00 2b 04 00 00 | 00 00 00 02 01 0b 50 48 |....+...|......PH|
|000000e0| 4f 4e 45 4e 55 4d 42 45 | 52 05 00 07 00 08 04 25 |ONENUMBE|R......%|
|000000f0| 00 00 00 0a 04 14 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000100| 04 00 00 00 00 29 04 14 | 00 00 00 2a 04 00 00 00 |.....)..|...*....|
|00000110| 00 2b 04 00 00 00 00 00 | 02 01 0b 43 4f 55 4e 54 |.+......|...COUNT|
|00000120| 52 59 4e 41 4d 45 05 00 | 07 00 08 04 25 00 00 00 |RYNAME..|....%...|
|00000130| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000140| 00 00 29 04 0f 00 00 00 | 2a 04 00 00 00 00 2b 04 |..).....|*.....+.|
|00000150| 00 00 00 00 00 02 01 0b | 41 44 44 52 45 53 53 4c |........|ADDRESSL|
|00000160| 49 4e 45 05 00 07 00 08 | 04 25 00 00 00 0a 04 1e |INE.....|.%......|
|00000170| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 29 |........|.......)|
|00000180| 04 1e 00 00 00 2a 04 00 | 00 00 00 2b 04 00 00 00 |.....*..|...+....|
|00000190| 00 00 02 01 05 45 4d 50 | 4e 4f 05 00 07 00 08 04 |.....EMP|NO......|
|000001a0| 07 00 00 00 0a 04 02 00 | 00 00 09 04 00 00 00 00 |........|........|
|000001b0| 0b 04 00 00 00 00 00 02 | 01 06 44 45 50 54 4e 4f |........|..DEPTNO|
|000001c0| 05 00 07 00 08 04 0e 00 | 00 00 0a 04 03 00 00 00 |........|........|
|000001d0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 14 04 32 00 |........|......2.|
|000001e0| 00 00 04 39 39 2f 18 00 | 00 00 15 0f 7f 00 03 00 |...99/..|........|
|000001f0| 30 30 30 3a 31 18 00 00 | 00 15 0f 7f 00 01 00 30 |000:1...|.......0|
|00000200| 34 18 00 00 00 15 0f 7f | 00 03 00 39 39 39 3d 18 |4.......|...999=.|
|00000210| 00 00 00 4c 24 04 4b 00 | 00 00 43 48 45 43 4b 20 |...L$.K.|..CHECK |
|00000220| 28 56 41 4c 55 45 20 3d | 20 27 30 30 30 27 20 4f |(VALUE =| '000' O|
|00000230| 52 20 28 56 41 4c 55 45 | 20 3e 20 27 30 27 20 41 |R (VALUE| > '0' A|
|00000240| 4e 44 20 56 41 4c 55 45 | 20 3c 3d 20 27 39 39 39 |ND VALUE| <= '999|
|00000250| 27 29 20 4f 52 20 56 41 | 4c 55 45 20 49 53 20 4e |') OR VA|LUE IS N|
|00000260| 55 4c 4c 29 00 29 04 03 | 00 00 00 2a 04 00 00 00 |ULL).)..|...*....|
|00000270| 00 2b 04 00 00 00 00 00 | 02 01 06 50 52 4f 4a 4e |.+......|...PROJN|
|00000280| 4f 05 00 07 00 08 04 0e | 00 00 00 0a 04 05 00 00 |O.......|........|
|00000290| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 14 04 0c |........|........|
|000002a0| 00 00 00 04 2f 18 00 00 | 00 67 18 00 00 00 4c 24 |..../...|.g....L$|
|000002b0| 04 1e 00 00 00 43 48 45 | 43 4b 20 28 56 41 4c 55 |.....CHE|CK (VALU|
|000002c0| 45 20 3d 20 55 50 50 45 | 52 20 28 56 41 4c 55 45 |E = UPPE|R (VALUE|
|000002d0| 29 29 00 29 04 05 00 00 | 00 2a 04 00 00 00 00 2b |)).)....|.*.....+|
|000002e0| 04 00 00 00 00 00 02 01 | 06 43 55 53 54 4e 4f 05 |........|.CUSTNO.|
|000002f0| 00 07 00 08 04 08 00 00 | 00 0a 04 04 00 00 00 09 |........|........|
|00000300| 04 00 00 00 00 0b 04 00 | 00 00 00 14 04 0e 00 00 |........|........|
|00000310| 00 04 31 18 00 00 00 15 | 08 00 e8 03 00 00 4c 24 |..1.....|......L$|
|00000320| 04 15 00 00 00 43 48 45 | 43 4b 20 28 56 41 4c 55 |.....CHE|CK (VALU|
|00000330| 45 20 3e 20 31 30 30 30 | 29 00 00 02 01 07 4a 4f |E > 1000|).....JO|
|00000340| 42 43 4f 44 45 05 00 07 | 00 08 04 25 00 00 00 0a |BCODE...|...%....|
|00000350| 04 05 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000360| 00 14 04 12 00 00 00 04 | 31 18 00 00 00 15 0f 7f |........|1.......|
|00000370| 00 05 00 39 39 39 39 39 | 4c 24 04 18 00 00 00 43 |...99999|L$.....C|
|00000380| 48 45 43 4b 20 28 56 41 | 4c 55 45 20 3e 20 27 39 |HECK (VA|LUE > '9|
|00000390| 39 39 39 39 27 29 00 29 | 04 05 00 00 00 2a 04 00 |9999').)|.....*..|
|000003a0| 00 00 00 2b 04 00 00 00 | 00 00 02 01 08 4a 4f 42 |...+....|.....JOB|
|000003b0| 47 52 41 44 45 05 00 07 | 00 08 04 07 00 00 00 0a |GRADE...|........|
|000003c0| 04 02 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|000003d0| 00 14 04 15 00 00 00 04 | 38 18 00 00 00 15 08 00 |........|8.......|
|000003e0| 00 00 00 00 15 08 00 06 | 00 00 00 4c 24 04 1e 00 |........|...L$...|
|000003f0| 00 00 43 48 45 43 4b 20 | 28 56 41 4c 55 45 20 42 |..CHECK |(VALUE B|
|00000400| 45 54 57 45 45 4e 20 30 | 20 41 4e 44 20 36 29 00 |ETWEEN 0| AND 6).|
|00000410| 00 02 01 06 53 41 4c 41 | 52 59 05 00 07 00 08 04 |....SALA|RY......|
|00000420| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000430| 0b 04 fe ff ff ff 0f 04 | 09 00 00 00 04 15 08 00 |........|........|
|00000440| 00 00 00 00 4c 14 04 0e | 00 00 00 04 31 18 00 00 |....L...|....1...|
|00000450| 00 15 08 00 00 00 00 00 | 4c 24 04 12 00 00 00 43 |........|L$.....C|
|00000460| 48 45 43 4b 20 28 56 41 | 4c 55 45 20 3e 20 30 29 |HECK (VA|LUE > 0)|
|00000470| 00 27 04 0a 00 00 00 44 | 45 46 41 55 4c 54 20 30 |.'.....D|EFAULT 0|
|00000480| 00 00 02 01 06 42 55 44 | 47 45 54 05 00 07 00 08 |.....BUD|GET.....|
|00000490| 04 1b 00 00 00 0a 04 08 | 00 00 00 09 04 00 00 00 |........|........|
|000004a0| 00 0b 04 fe ff ff ff 0f | 04 09 00 00 00 04 15 08 |........|........|
|000004b0| 00 50 c3 00 00 4c 14 04 | 1b 00 00 00 04 3a 31 18 |.P...L..|.....:1.|
|000004c0| 00 00 00 15 08 00 10 27 | 00 00 34 18 00 00 00 15 |.......'|..4.....|
|000004d0| 08 00 80 84 1e 00 4c 24 | 04 2b 00 00 00 43 48 45 |......L$|.+...CHE|
|000004e0| 43 4b 20 28 56 41 4c 55 | 45 20 3e 20 31 30 30 30 |CK (VALU|E > 1000|
|000004f0| 30 20 41 4e 44 20 56 41 | 4c 55 45 20 3c 3d 20 32 |0 AND VA|LUE <= 2|
|00000500| 30 30 30 30 30 30 29 00 | 27 04 0e 00 00 00 44 45 |000000).|'.....DE|
|00000510| 46 41 55 4c 54 20 35 30 | 30 30 30 00 00 02 01 08 |FAULT 50|000.....|
|00000520| 50 52 4f 44 54 59 50 45 | 05 00 07 00 08 04 25 00 |PRODTYPE|......%.|
|00000530| 00 00 0a 04 0c 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000540| 00 00 00 00 0f 04 10 00 | 00 00 04 15 0f 7f 00 08 |........|........|
|00000550| 00 73 6f 66 74 77 61 72 | 65 4c 14 04 49 00 00 00 |.softwar|eL..I...|
|00000560| 04 39 39 39 2f 18 00 00 | 00 15 0f 7f 00 08 00 73 |.999/...|.......s|
|00000570| 6f 66 74 77 61 72 65 2f | 18 00 00 00 15 0f 7f 00 |oftware/|........|
|00000580| 08 00 68 61 72 64 77 61 | 72 65 2f 18 00 00 00 15 |..hardwa|re/.....|
|00000590| 0f 7f 00 05 00 6f 74 68 | 65 72 2f 18 00 00 00 15 |.....oth|er/.....|
|000005a0| 0f 7f 00 03 00 4e 2f 41 | 4c 24 04 3a 00 00 00 43 |.....N/A|L$.:...C|
|000005b0| 48 45 43 4b 20 28 56 41 | 4c 55 45 20 49 4e 20 28 |HECK (VA|LUE IN (|
|000005c0| 27 73 6f 66 74 77 61 72 | 65 27 2c 20 27 68 61 72 |'softwar|e', 'har|
|000005d0| 64 77 61 72 65 27 2c 20 | 27 6f 74 68 65 72 27 2c |dware', |'other',|
|000005e0| 20 27 4e 2f 41 27 29 29 | 00 26 04 01 00 00 00 29 | 'N/A'))|.&.....)|
|000005f0| 04 0c 00 00 00 27 04 13 | 00 00 00 44 45 46 41 55 |.....'..|...DEFAU|
|00000600| 4c 54 20 27 73 6f 66 74 | 77 61 72 65 27 00 2a 04 |LT 'soft|ware'.*.|
|00000610| 00 00 00 00 2b 04 00 00 | 00 00 00 02 01 08 50 4f |....+...|......PO|
|00000620| 4e 55 4d 42 45 52 05 00 | 07 00 08 04 0e 00 00 00 |NUMBER..|........|
|00000630| 0a 04 08 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000640| 00 00 14 04 0e 00 00 00 | 04 37 18 00 00 00 15 0f |........|.7......|
|00000650| 7f 00 01 00 56 4c 24 04 | 20 00 00 00 43 48 45 43 |....VL$.| ...CHEC|
|00000660| 4b 20 28 56 41 4c 55 45 | 20 53 54 41 52 54 49 4e |K (VALUE| STARTIN|
|00000670| 47 20 57 49 54 48 20 27 | 56 27 29 00 29 04 08 00 |G WITH '|V').)...|
|00000680| 00 00 2a 04 00 00 00 00 | 2b 04 00 00 00 00 00 02 |..*.....|+.......|
|00000690| 01 05 52 44 42 24 31 05 | 00 07 00 08 04 25 00 00 |..RDB$1.|.....%..|
|000006a0| 00 0a 04 0a 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000006b0| 00 00 00 29 04 0a 00 00 | 00 2a 04 00 00 00 00 00 |...)....|.*......|
|000006c0| 02 01 05 52 44 42 24 32 | 05 00 07 00 08 04 25 00 |...RDB$2|......%.|
|000006d0| 00 00 0a 04 19 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000006e0| 00 00 00 00 29 04 19 00 | 00 00 2a 04 00 00 00 00 |....)...|..*.....|
|000006f0| 00 02 01 05 52 44 42 24 | 33 05 00 07 00 08 04 05 |....RDB$|3.......|
|00000700| 01 00 00 0a 04 08 00 00 | 00 09 04 01 00 00 00 0b |........|........|
|00000710| 04 00 00 00 00 0c 04 90 | 01 00 00 2a 04 00 00 00 |........|...*....|
|00000720| 00 00 02 01 05 52 44 42 | 24 34 05 00 07 00 08 04 |.....RDB|$4......|
|00000730| 25 00 00 00 0a 04 0f 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00000740| 0b 04 00 00 00 00 1d 04 | 01 00 00 00 29 04 0f 00 |........|....)...|
|00000750| 00 00 2a 04 00 00 00 00 | 00 02 01 05 52 44 42 24 |..*.....|....RDB$|
|00000760| 35 05 00 07 00 08 04 25 | 00 00 00 0a 04 19 00 00 |5......%|........|
|00000770| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 19 |........|.....)..|
|00000780| 00 00 00 2a 04 00 00 00 | 00 00 02 01 05 52 44 42 |...*....|.....RDB|
|00000790| 24 36 05 00 07 00 08 04 | 25 00 00 00 0a 04 0f 00 |$6......|%.......|
|000007a0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|000007b0| 0f 00 00 00 2a 04 00 00 | 00 00 00 02 01 05 52 44 |....*...|......RD|
|000007c0| 42 24 37 05 00 07 00 08 | 04 25 00 00 00 0a 04 04 |B$7.....|.%......|
|000007d0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 29 |........|.......)|
|000007e0| 04 04 00 00 00 2a 04 00 | 00 00 00 00 02 01 05 52 |.....*..|.......R|
|000007f0| 44 42 24 38 05 00 07 00 | 08 04 23 00 00 00 0a 04 |DB$8....|..#.....|
|00000800| 08 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000810| 00 02 01 05 52 44 42 24 | 39 05 00 07 00 08 04 25 |....RDB$|9......%|
|00000820| 00 00 00 0a 04 25 00 00 | 00 09 04 00 00 00 00 0b |.....%..|........|
|00000830| 04 00 00 00 00 12 04 25 | 00 00 00 04 27 27 17 00 |.......%|....''..|
|00000840| 09 4c 41 53 54 5f 4e 41 | 4d 45 15 0f 7f 00 02 00 |.LAST_NA|ME......|
|00000850| 2c 20 17 00 0a 46 49 52 | 53 54 5f 4e 41 4d 45 4c |, ...FIR|ST_NAMEL|
|00000860| 25 04 22 00 00 00 28 6c | 61 73 74 5f 6e 61 6d 65 |%."...(l|ast_name|
|00000870| 20 7c 7c 20 27 2c 20 27 | 20 7c 7c 20 66 69 72 73 | || ', '| || firs|
|00000880| 74 5f 6e 61 6d 65 29 00 | 29 04 00 00 00 00 2a 04 |t_name).|).....*.|
|00000890| 00 00 00 00 00 02 01 06 | 52 44 42 24 31 30 05 00 |........|RDB$10..|
|000008a0| 07 00 08 04 25 00 00 00 | 0a 04 14 00 00 00 09 04 |....%...|........|
|000008b0| 00 00 00 00 0b 04 00 00 | 00 00 29 04 14 00 00 00 |........|..).....|
|000008c0| 2a 04 00 00 00 00 00 02 | 01 06 52 44 42 24 31 31 |*.......|..RDB$11|
|000008d0| 05 00 07 00 08 04 05 01 | 00 00 0a 04 08 00 00 00 |........|........|
|000008e0| 09 04 01 00 00 00 0b 04 | 00 00 00 00 0c 04 20 03 |........|...... .|
|000008f0| 00 00 2a 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..*.....|....RDB$|
|00000900| 31 32 05 00 07 00 08 04 | 08 00 00 00 0a 04 04 00 |12......|........|
|00000910| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 00 02 |........|........|
|00000920| 01 06 52 44 42 24 31 33 | 05 00 07 00 08 04 08 00 |..RDB$13|........|
|00000930| 00 00 0a 04 04 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000940| 00 00 00 00 1d 04 01 00 | 00 00 00 02 01 06 52 44 |........|......RD|
|00000950| 42 24 31 34 05 00 07 00 | 08 04 23 00 00 00 0a 04 |B$14....|..#.....|
|00000960| 08 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000970| 00 02 01 06 52 44 42 24 | 31 35 05 00 07 00 08 04 |....RDB$|15......|
|00000980| 25 00 00 00 0a 04 14 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|00000990| 0b 04 00 00 00 00 29 04 | 14 00 00 00 2a 04 00 00 |......).|....*...|
|000009a0| 00 00 00 02 01 06 52 44 | 42 24 31 36 05 00 07 00 |......RD|B$16....|
|000009b0| 08 04 1b 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |........|........|
|000009c0| 00 00 0b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |........|....RDB$|
|000009d0| 31 37 05 00 07 00 08 04 | 1b 00 00 00 0a 04 08 00 |17......|........|
|000009e0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 12 04 |........|........|
|000009f0| 37 00 00 00 04 22 17 00 | 0a 4f 4c 44 5f 53 41 4c |7...."..|.OLD_SAL|
|00000a00| 41 52 59 25 24 17 00 0a | 4f 4c 44 5f 53 41 4c 41 |ARY%$...|OLD_SALA|
|00000a10| 52 59 17 00 0e 50 45 52 | 43 45 4e 54 5f 43 48 41 |RY...PER|CENT_CHA|
|00000a20| 4e 47 45 15 08 00 64 00 | 00 00 4c 25 04 31 00 00 |NGE...d.|..L%.1..|
|00000a30| 00 28 6f 6c 64 5f 73 61 | 6c 61 72 79 20 2b 20 6f |.(old_sa|lary + o|
|00000a40| 6c 64 5f 73 61 6c 61 72 | 79 20 2a 20 70 65 72 63 |ld_salar|y * perc|
|00000a50| 65 6e 74 5f 63 68 61 6e | 67 65 20 2f 20 31 30 30 |ent_chan|ge / 100|
|00000a60| 29 00 00 02 01 06 52 44 | 42 24 31 38 05 00 07 00 |).....RD|B$18....|
|00000a70| 08 04 25 00 00 00 0a 04 | 19 00 00 00 09 04 00 00 |..%.....|........|
|00000a80| 00 00 0b 04 00 00 00 00 | 29 04 19 00 00 00 2a 04 |........|).....*.|
|00000a90| 00 00 00 00 00 02 01 06 | 52 44 42 24 31 39 05 00 |........|RDB$19..|
|00000aa0| 07 00 08 04 25 00 00 00 | 0a 04 19 00 00 00 09 04 |....%...|........|
|00000ab0| 00 00 00 00 0b 04 00 00 | 00 00 29 04 19 00 00 00 |........|..).....|
|00000ac0| 2a 04 00 00 00 00 00 02 | 01 06 52 44 42 24 32 30 |*.......|..RDB$20|
|00000ad0| 05 00 07 00 08 04 25 00 | 00 00 0a 04 0f 00 00 00 |......%.|........|
|00000ae0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 29 04 0f 00 |........|....)...|
|00000af0| 00 00 2a 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |..*.....|....RDB$|
|00000b00| 32 31 05 00 07 00 08 04 | 25 00 00 00 0a 04 0c 00 |21......|%.......|
|00000b10| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 29 04 |........|......).|
|00000b20| 0c 00 00 00 2a 04 00 00 | 00 00 00 02 01 06 52 44 |....*...|......RD|
|00000b30| 42 24 32 32 05 00 07 00 | 08 04 0e 00 00 00 0a 04 |B$22....|........|
|00000b40| 01 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000b50| 29 04 01 00 00 00 2a 04 | 00 00 00 00 00 02 01 06 |).....*.|........|
|00000b60| 52 44 42 24 32 33 05 00 | 07 00 08 04 25 00 00 00 |RDB$23..|....%...|
|00000b70| 0a 04 07 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00000b80| 00 00 29 04 07 00 00 00 | 2a 04 00 00 00 00 00 02 |..).....|*.......|
|00000b90| 01 06 52 44 42 24 32 34 | 05 00 07 00 08 04 23 00 |..RDB$24|......#.|
|00000ba0| 00 00 0a 04 08 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000bb0| 00 00 00 00 00 02 01 06 | 52 44 42 24 32 35 05 00 |........|RDB$25..|
|00000bc0| 07 00 08 04 23 00 00 00 | 0a 04 08 00 00 00 09 04 |....#...|........|
|00000bd0| 00 00 00 00 0b 04 00 00 | 00 00 00 02 01 06 52 44 |........|......RD|
|00000be0| 42 24 32 36 05 00 07 00 | 08 04 23 00 00 00 0a 04 |B$26....|..#.....|
|00000bf0| 08 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00000c00| 00 02 01 06 52 44 42 24 | 32 37 05 00 07 00 08 04 |....RDB$|27......|
|00000c10| 0e 00 00 00 0a 04 01 00 | 00 00 09 04 00 00 00 00 |........|........|
|00000c20| 0b 04 00 00 00 00 29 04 | 01 00 00 00 2a 04 00 00 |......).|....*...|
|00000c30| 00 00 00 02 01 06 52 44 | 42 24 32 38 05 00 07 00 |......RD|B$28....|
|00000c40| 08 04 08 00 00 00 0a 04 | 04 00 00 00 09 04 00 00 |........|........|
|00000c50| 00 00 0b 04 00 00 00 00 | 00 02 01 06 52 44 42 24 |........|....RDB$|
|00000c60| 32 39 05 00 07 00 08 04 | 08 00 00 00 0a 04 04 00 |29......|........|
|00000c70| 00 00 09 04 00 00 00 00 | 0b 04 fe ff ff ff 00 02 |........|........|
|00000c80| 01 06 52 44 42 24 33 30 | 05 00 07 00 08 04 0a 00 |..RDB$30|........|
|00000c90| 00 00 0a 04 04 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00000ca0| 00 00 00 00 00 02 01 06 | 52 44 42 24 33 31 05 00 |........|RDB$31..|
|00000cb0| 07 00 08 04 1b 00 00 00 | 0a 04 08 00 00 00 09 04 |........|........|
|00000cc0| 00 00 00 00 0b 04 00 00 | 00 00 12 04 1c 00 00 00 |........|........|
|00000cd0| 04 23 17 00 09 53 48 49 | 50 5f 44 41 54 45 17 00 |.#...SHI|P_DATE..|
|00000ce0| 0a 4f 52 44 45 52 5f 44 | 41 54 45 4c 25 04 19 00 |.ORDER_D|ATEL%...|
|00000cf0| 00 00 28 73 68 69 70 5f | 64 61 74 65 20 2d 20 6f |..(ship_|date - o|
|00000d00| 72 64 65 72 5f 64 61 74 | 65 29 00 00 02 01 06 52 |rder_dat|e).....R|
|00000d10| 44 42 24 33 32 05 00 07 | 00 08 04 07 00 00 00 0a |DB$32...|........|
|00000d20| 04 02 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000d30| 00 00 02 01 06 52 44 42 | 24 33 33 05 00 07 00 08 |.....RDB|$33.....|
|00000d40| 04 0e 00 00 00 0a 04 05 | 00 00 00 09 04 00 00 00 |........|........|
|00000d50| 00 0b 04 00 00 00 00 29 | 04 05 00 00 00 2a 04 00 |.......)|.....*..|
|00000d60| 00 00 00 2b 04 00 00 00 | 00 00 02 01 06 52 44 42 |...+....|.....RDB|
|00000d70| 24 33 34 05 00 07 00 08 | 04 07 00 00 00 0a 04 02 |$34.....|........|
|00000d80| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 00 |........|........|
|00000d90| 02 01 06 52 44 42 24 33 | 35 05 00 07 00 08 04 0e |...RDB$3|5.......|
|00000da0| 00 00 00 0a 04 05 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000db0| 04 00 00 00 00 29 04 05 | 00 00 00 2a 04 00 00 00 |.....)..|...*....|
|00000dc0| 00 2b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 33 |.+......|...RDB$3|
|00000dd0| 36 05 00 07 00 08 04 0e | 00 00 00 0a 04 03 00 00 |6.......|........|
|00000de0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 03 |........|.....)..|
|00000df0| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00000e00| 02 01 06 52 44 42 24 33 | 37 05 00 07 00 08 04 1b |...RDB$3|7.......|
|00000e10| 00 00 00 0a 04 08 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00000e20| 04 fe ff ff ff 00 02 01 | 06 52 44 42 24 33 38 05 |........|.RDB$38.|
|00000e30| 00 07 00 08 04 1b 00 00 | 00 0a 04 08 00 00 00 09 |........|........|
|00000e40| 04 00 00 00 00 0b 04 fe | ff ff ff 00 02 01 06 52 |........|.......R|
|00000e50| 44 42 24 33 39 05 00 07 | 00 08 04 1b 00 00 00 0a |DB$39...|........|
|00000e60| 04 08 00 00 00 09 04 00 | 00 00 00 0b 04 fe ff ff |........|........|
|00000e70| ff 00 02 01 06 52 44 42 | 24 34 30 05 00 07 00 08 |.....RDB|$40.....|
|00000e80| 04 1b 00 00 00 0a 04 08 | 00 00 00 09 04 00 00 00 |........|........|
|00000e90| 00 0b 04 fe ff ff ff 00 | 02 01 06 52 44 42 24 34 |........|...RDB$4|
|00000ea0| 31 05 00 07 00 08 04 08 | 00 00 00 0a 04 04 00 00 |1.......|........|
|00000eb0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 00 02 01 |........|........|
|00000ec0| 06 52 44 42 24 34 32 05 | 00 07 00 08 04 0e 00 00 |.RDB$42.|........|
|00000ed0| 00 0a 04 03 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00000ee0| 00 00 00 29 04 03 00 00 | 00 2a 04 00 00 00 00 2b |...)....|.*.....+|
|00000ef0| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 34 33 05 |........|.RDB$43.|
|00000f00| 00 07 00 08 04 1b 00 00 | 00 0a 04 08 00 00 00 09 |........|........|
|00000f10| 04 00 00 00 00 0b 04 fe | ff ff ff 00 02 01 06 52 |........|.......R|
|00000f20| 44 42 24 34 34 05 00 07 | 00 08 04 0e 00 00 00 0a |DB$44...|........|
|00000f30| 04 19 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000f40| 00 29 04 19 00 00 00 2a | 04 00 00 00 00 2b 04 00 |.).....*|.....+..|
|00000f50| 00 00 00 00 02 01 06 52 | 44 42 24 34 35 05 00 07 |.......R|DB$45...|
|00000f60| 00 08 04 0e 00 00 00 0a | 04 19 00 00 00 09 04 00 |........|........|
|00000f70| 00 00 00 0b 04 00 00 00 | 00 29 04 19 00 00 00 2a |........|.).....*|
|00000f80| 04 00 00 00 00 2b 04 00 | 00 00 00 00 02 01 06 52 |.....+..|.......R|
|00000f90| 44 42 24 34 36 05 00 07 | 00 08 04 0e 00 00 00 0a |DB$46...|........|
|00000fa0| 04 14 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00000fb0| 00 29 04 14 00 00 00 2a | 04 00 00 00 00 2b 04 00 |.).....*|.....+..|
|00000fc0| 00 00 00 00 02 01 06 52 | 44 42 24 34 37 05 00 07 |.......R|DB$47...|
|00000fd0| 00 08 04 0e 00 00 00 0a | 04 05 00 00 00 09 04 00 |........|........|
|00000fe0| 00 00 00 0b 04 00 00 00 | 00 29 04 05 00 00 00 2a |........|.).....*|
|00000ff0| 04 00 00 00 00 2b 04 00 | 00 00 00 00 02 01 06 52 |.....+..|.......R|
|00001000| 44 42 24 34 38 05 00 07 | 00 08 04 08 00 00 00 0a |DB$48...|........|
|00001010| 04 04 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00001020| 00 00 02 01 06 52 44 42 | 24 34 39 05 00 07 00 08 |.....RDB|$49.....|
|00001030| 04 08 00 00 00 0a 04 04 | 00 00 00 09 04 00 00 00 |........|........|
|00001040| 00 0b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 35 |........|...RDB$5|
|00001050| 30 05 00 07 00 08 04 0e | 00 00 00 0a 04 28 00 00 |0.......|.....(..|
|00001060| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 28 |........|.....).(|
|00001070| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00001080| 02 01 06 52 44 42 24 35 | 31 05 00 07 00 08 04 0e |...RDB$5|1.......|
|00001090| 00 00 00 0a 04 28 00 00 | 00 09 04 00 00 00 00 0b |.....(..|........|
|000010a0| 04 00 00 00 00 29 04 28 | 00 00 00 2a 04 00 00 00 |.....).(|...*....|
|000010b0| 00 2b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 35 |.+......|...RDB$5|
|000010c0| 32 05 00 07 00 08 04 0e | 00 00 00 0a 04 28 00 00 |2.......|.....(..|
|000010d0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 28 |........|.....).(|
|000010e0| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|000010f0| 02 01 06 52 44 42 24 35 | 33 05 00 07 00 08 04 0e |...RDB$5|3.......|
|00001100| 00 00 00 0a 04 28 00 00 | 00 09 04 00 00 00 00 0b |.....(..|........|
|00001110| 04 00 00 00 00 29 04 28 | 00 00 00 2a 04 00 00 00 |.....).(|...*....|
|00001120| 00 2b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 35 |.+......|...RDB$5|
|00001130| 34 05 00 07 00 08 04 0e | 00 00 00 0a 04 28 00 00 |4.......|.....(..|
|00001140| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 28 |........|.....).(|
|00001150| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00001160| 02 01 06 52 44 42 24 35 | 35 05 00 07 00 08 04 0e |...RDB$5|5.......|
|00001170| 00 00 00 0a 04 28 00 00 | 00 09 04 00 00 00 00 0b |.....(..|........|
|00001180| 04 00 00 00 00 29 04 28 | 00 00 00 2a 04 00 00 00 |.....).(|...*....|
|00001190| 00 2b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 35 |.+......|...RDB$5|
|000011a0| 36 05 00 07 00 08 04 0e | 00 00 00 0a 04 08 00 00 |6.......|........|
|000011b0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 29 04 08 |........|.....)..|
|000011c0| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|000011d0| 02 01 06 52 44 42 24 35 | 37 05 00 07 00 08 04 25 |...RDB$5|7......%|
|000011e0| 00 00 00 0a 04 05 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|000011f0| 04 00 00 00 00 29 04 05 | 00 00 00 2a 04 00 00 00 |.....)..|...*....|
|00001200| 00 2b 04 00 00 00 00 00 | 02 01 06 52 44 42 24 35 |.+......|...RDB$5|
|00001210| 38 05 00 07 00 08 04 07 | 00 00 00 0a 04 02 00 00 |8.......|........|
|00001220| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 00 02 01 |........|........|
|00001230| 06 52 44 42 24 35 39 05 | 00 07 00 08 04 25 00 00 |.RDB$59.|.....%..|
|00001240| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001250| 00 00 00 29 04 0f 00 00 | 00 2a 04 00 00 00 00 2b |...)....|.*.....+|
|00001260| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 36 30 05 |........|.RDB$60.|
|00001270| 00 07 00 08 04 25 00 00 | 00 0a 04 0f 00 00 00 09 |.....%..|........|
|00001280| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 0f 00 00 |........|...)....|
|00001290| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|000012a0| 06 52 44 42 24 36 31 05 | 00 07 00 08 04 25 00 00 |.RDB$61.|.....%..|
|000012b0| 00 0a 04 05 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000012c0| 00 00 00 29 04 05 00 00 | 00 2a 04 00 00 00 00 2b |...)....|.*.....+|
|000012d0| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 36 32 05 |........|.RDB$62.|
|000012e0| 00 07 00 08 04 25 00 00 | 00 0a 04 05 00 00 00 09 |.....%..|........|
|000012f0| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 05 00 00 |........|...)....|
|00001300| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 02 01 |.*.....+|........|
|00001310| 06 52 44 42 24 36 33 05 | 00 07 00 08 04 25 00 00 |.RDB$63.|.....%..|
|00001320| 00 0a 04 0f 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001330| 00 00 00 29 04 0f 00 00 | 00 2a 04 00 00 00 00 2b |...)....|.*.....+|
|00001340| 04 00 00 00 00 00 02 01 | 06 52 44 42 24 36 34 05 |........|.RDB$64.|
|00001350| 00 07 00 08 04 25 00 00 | 00 0a 04 0f 00 00 00 09 |.....%..|........|
|00001360| 04 00 00 00 00 0b 04 00 | 00 00 00 29 04 0f 00 00 |........|...)....|
|00001370| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 18 01 |.*.....+|........|
|00001380| 05 52 44 42 24 34 1d 04 | 00 00 00 00 20 04 01 00 |.RDB$4..|.... ...|
|00001390| 00 00 21 04 05 00 00 00 | 00 18 01 06 52 44 42 24 |..!.....|....RDB$|
|000013a0| 31 33 1d 04 00 00 00 00 | 20 04 01 00 00 00 21 04 |13......| .....!.|
|000013b0| 04 00 00 00 00 03 01 07 | 43 4f 55 4e 54 52 59 10 |........|COUNTRY.|
|000013c0| 04 01 00 00 00 08 0b 53 | 51 4c 24 43 4f 55 4e 54 |.......S|QL$COUNT|
|000013d0| 52 59 0c 06 53 59 53 44 | 42 41 00 04 01 08 43 55 |RY..SYSD|BA....CU|
|000013e0| 52 52 45 4e 43 59 02 05 | 52 44 42 24 31 0d 04 01 |RRENCY..|RDB$1...|
|000013f0| 00 00 00 08 04 25 00 00 | 00 0a 04 0a 00 00 00 09 |.....%..|........|
|00001400| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 02 00 00 |........|........|
|00001410| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00001420| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00001430| 04 01 07 43 4f 55 4e 54 | 52 59 02 0b 43 4f 55 4e |...COUNT|RY..COUN|
|00001440| 54 52 59 4e 41 4d 45 0d | 04 00 00 00 00 08 04 25 |TRYNAME.|.......%|
|00001450| 00 00 00 0a 04 0f 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00001460| 04 00 00 00 00 16 04 01 | 00 00 00 18 04 00 00 00 |........|........|
|00001470| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 2a 04 00 |.".....&|.....*..|
|00001480| 00 00 00 00 09 03 01 03 | 4a 4f 42 10 04 01 00 00 |........|JOB.....|
|00001490| 00 08 07 53 51 4c 24 4a | 4f 42 0c 06 53 59 53 44 |...SQL$J|OB..SYSD|
|000014a0| 42 41 00 04 01 0f 4a 4f | 42 5f 52 45 51 55 49 52 |BA....JO|B_REQUIR|
|000014b0| 45 4d 45 4e 54 02 05 52 | 44 42 24 33 0d 04 06 00 |EMENT..R|DB$3....|
|000014c0| 00 00 08 04 05 01 00 00 | 0a 04 08 00 00 00 09 04 |........|........|
|000014d0| 01 00 00 00 0b 04 00 00 | 00 00 16 04 07 00 00 00 |........|........|
|000014e0| 18 04 00 00 00 00 22 04 | 01 00 00 00 2a 04 00 00 |......".|....*...|
|000014f0| 00 00 00 04 01 0a 4d 41 | 58 5f 53 41 4c 41 52 59 |......MA|X_SALARY|
|00001500| 02 06 53 41 4c 41 52 59 | 0d 04 05 00 00 00 08 04 |..SALARY|........|
|00001510| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|00001520| 0b 04 fe ff ff ff 16 04 | 06 00 00 00 18 04 00 00 |........|........|
|00001530| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 00 04 |..".....|&.......|
|00001540| 01 0a 4d 49 4e 5f 53 41 | 4c 41 52 59 02 06 53 41 |..MIN_SA|LARY..SA|
|00001550| 4c 41 52 59 0d 04 04 00 | 00 00 08 04 1b 00 00 00 |LARY....|........|
|00001560| 0a 04 08 00 00 00 09 04 | 00 00 00 00 0b 04 fe ff |........|........|
|00001570| ff ff 16 04 05 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00001580| 01 00 00 00 26 04 01 00 | 00 00 00 04 01 09 4a 4f |....&...|......JO|
|00001590| 42 5f 47 52 41 44 45 02 | 08 4a 4f 42 47 52 41 44 |B_GRADE.|.JOBGRAD|
|000015a0| 45 0d 04 01 00 00 00 08 | 04 07 00 00 00 0a 04 02 |E.......|........|
|000015b0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|000015c0| 04 02 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|000015d0| 00 26 04 01 00 00 00 00 | 04 01 0c 4c 41 4e 47 55 |.&......|...LANGU|
|000015e0| 41 47 45 5f 52 45 51 02 | 05 52 44 42 24 34 0d 04 |AGE_REQ.|.RDB$4..|
|000015f0| 07 00 00 00 08 04 25 00 | 00 00 0a 04 0f 00 00 00 |......%.|........|
|00001600| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 08 00 |........|........|
|00001610| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 2a 04 |........|".....*.|
|00001620| 00 00 00 00 2b 04 00 00 | 00 00 1d 04 01 00 00 00 |....+...|........|
|00001630| 20 04 01 00 00 00 21 04 | 05 00 00 00 00 04 01 09 | .....!.|........|
|00001640| 4a 4f 42 5f 54 49 54 4c | 45 02 05 52 44 42 24 32 |JOB_TITL|E..RDB$2|
|00001650| 0d 04 03 00 00 00 08 04 | 25 00 00 00 0a 04 19 00 |........|%.......|
|00001660| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00001670| 04 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00001680| 26 04 01 00 00 00 2a 04 | 00 00 00 00 2b 04 00 00 |&.....*.|....+...|
|00001690| 00 00 00 04 01 0b 4a 4f | 42 5f 43 4f 55 4e 54 52 |......JO|B_COUNTR|
|000016a0| 59 02 0b 43 4f 55 4e 54 | 52 59 4e 41 4d 45 0d 04 |Y..COUNT|RYNAME..|
|000016b0| 02 00 00 00 08 04 25 00 | 00 00 0a 04 0f 00 00 00 |......%.|........|
|000016c0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 03 00 |........|........|
|000016d0| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|000016e0| 01 00 00 00 2a 04 00 00 | 00 00 00 04 01 08 4a 4f |....*...|......JO|
|000016f0| 42 5f 43 4f 44 45 02 07 | 4a 4f 42 43 4f 44 45 0d |B_CODE..|JOBCODE.|
|00001700| 04 00 00 00 00 08 04 25 | 00 00 00 0a 04 05 00 00 |.......%|........|
|00001710| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 01 |........|........|
|00001720| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00001730| 04 01 00 00 00 2a 04 00 | 00 00 00 00 09 03 01 0a |.....*..|........|
|00001740| 44 45 50 41 52 54 4d 45 | 4e 54 10 04 01 00 00 00 |DEPARTME|NT......|
|00001750| 08 0e 53 51 4c 24 44 45 | 50 41 52 54 4d 45 4e 54 |..SQL$DE|PARTMENT|
|00001760| 0c 06 53 59 53 44 42 41 | 00 04 01 06 42 55 44 47 |..SYSDBA|....BUDG|
|00001770| 45 54 02 06 42 55 44 47 | 45 54 0d 04 04 00 00 00 |ET..BUDG|ET......|
|00001780| 08 04 1b 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |........|........|
|00001790| 00 00 0b 04 fe ff ff ff | 16 04 05 00 00 00 18 04 |........|........|
|000017a0| 00 00 00 00 22 04 01 00 | 00 00 00 04 01 08 50 48 |...."...|......PH|
|000017b0| 4f 4e 45 5f 4e 4f 02 0b | 50 48 4f 4e 45 4e 55 4d |ONE_NO..|PHONENUM|
|000017c0| 42 45 52 0d 04 06 00 00 | 00 08 04 25 00 00 00 0a |BER.....|...%....|
|000017d0| 04 14 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|000017e0| 00 16 04 07 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|000017f0| 00 00 00 2a 04 00 00 00 | 00 0f 04 10 00 00 00 04 |...*....|........|
|00001800| 15 0f 7f 00 08 00 35 35 | 35 2d 31 32 33 34 4c 27 |......55|5-1234L'|
|00001810| 04 14 00 00 00 20 44 45 | 46 41 55 4c 54 20 27 35 |..... DE|FAULT '5|
|00001820| 35 35 2d 31 32 33 34 27 | 00 00 04 01 07 4d 4e 47 |55-1234'|.....MNG|
|00001830| 52 5f 4e 4f 02 05 45 4d | 50 4e 4f 0d 04 03 00 00 |R_NO..EM|PNO.....|
|00001840| 00 08 04 07 00 00 00 0a | 04 02 00 00 00 09 04 00 |........|........|
|00001850| 00 00 00 0b 04 00 00 00 | 00 16 04 04 00 00 00 18 |........|........|
|00001860| 04 00 00 00 00 22 04 01 | 00 00 00 00 04 01 08 4c |....."..|.......L|
|00001870| 4f 43 41 54 49 4f 4e 02 | 05 52 44 42 24 36 0d 04 |OCATION.|.RDB$6..|
|00001880| 05 00 00 00 08 04 25 00 | 00 00 0a 04 0f 00 00 00 |......%.|........|
|00001890| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 06 00 |........|........|
|000018a0| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 2a 04 |........|".....*.|
|000018b0| 00 00 00 00 2b 04 00 00 | 00 00 00 04 01 09 48 45 |....+...|......HE|
|000018c0| 41 44 5f 44 45 50 54 02 | 06 44 45 50 54 4e 4f 0d |AD_DEPT.|.DEPTNO.|
|000018d0| 04 02 00 00 00 08 04 0e | 00 00 00 0a 04 03 00 00 |........|........|
|000018e0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 03 |........|........|
|000018f0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 2a |........|.".....*|
|00001900| 04 00 00 00 00 00 04 01 | 0a 44 45 50 41 52 54 4d |........|.DEPARTM|
|00001910| 45 4e 54 02 05 52 44 42 | 24 35 0d 04 01 00 00 00 |ENT..RDB|$5......|
|00001920| 08 04 25 00 00 00 0a 04 | 19 00 00 00 09 04 00 00 |..%.....|........|
|00001930| 00 00 0b 04 00 00 00 00 | 16 04 02 00 00 00 18 04 |........|........|
|00001940| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00001950| 2a 04 00 00 00 00 2b 04 | 00 00 00 00 00 04 01 07 |*.....+.|........|
|00001960| 44 45 50 54 5f 4e 4f 02 | 06 44 45 50 54 4e 4f 0d |DEPT_NO.|.DEPTNO.|
|00001970| 04 00 00 00 00 08 04 0e | 00 00 00 0a 04 03 00 00 |........|........|
|00001980| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 01 |........|........|
|00001990| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|000019a0| 04 01 00 00 00 2a 04 00 | 00 00 00 00 09 03 01 08 |.....*..|........|
|000019b0| 45 4d 50 4c 4f 59 45 45 | 10 04 01 00 00 00 08 0c |EMPLOYEE|........|
|000019c0| 53 51 4c 24 45 4d 50 4c | 4f 59 45 45 0c 06 53 59 |SQL$EMPL|OYEE..SY|
|000019d0| 53 44 42 41 00 04 01 06 | 53 41 4c 41 52 59 02 06 |SDBA....|SALARY..|
|000019e0| 53 41 4c 41 52 59 0d 04 | 09 00 00 00 08 04 1b 00 |SALARY..|........|
|000019f0| 00 00 0a 04 08 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00001a00| fe ff ff ff 16 04 0a 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001a10| 22 04 01 00 00 00 26 04 | 01 00 00 00 00 04 01 09 |".....&.|........|
|00001a20| 48 49 52 45 5f 44 41 54 | 45 02 05 52 44 42 24 38 |HIRE_DAT|E..RDB$8|
|00001a30| 0d 04 04 00 00 00 08 04 | 23 00 00 00 0a 04 08 00 |........|#.......|
|00001a40| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|00001a50| 05 00 00 00 18 04 00 00 | 00 00 22 04 01 00 00 00 |........|..".....|
|00001a60| 26 04 01 00 00 00 0f 04 | 0b 00 00 00 04 15 0f 7f |&.......|........|
|00001a70| 00 03 00 4e 4f 57 4c 27 | 04 0e 00 00 00 44 45 46 |...NOWL'|.....DEF|
|00001a80| 41 55 4c 54 20 27 4e 4f | 57 27 00 00 04 01 09 4a |AULT 'NO|W'.....J|
|00001a90| 4f 42 5f 47 52 41 44 45 | 02 08 4a 4f 42 47 52 41 |OB_GRADE|..JOBGRA|
|00001aa0| 44 45 0d 04 07 00 00 00 | 08 04 07 00 00 00 0a 04 |DE......|........|
|00001ab0| 02 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00001ac0| 16 04 08 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00001ad0| 00 00 26 04 01 00 00 00 | 00 04 01 09 50 48 4f 4e |..&.....|....PHON|
|00001ae0| 45 5f 45 58 54 02 05 52 | 44 42 24 37 0d 04 03 00 |E_EXT..R|DB$7....|
|00001af0| 00 00 08 04 25 00 00 00 | 0a 04 04 00 00 00 09 04 |....%...|........|
|00001b00| 00 00 00 00 0b 04 00 00 | 00 00 16 04 04 00 00 00 |........|........|
|00001b10| 18 04 00 00 00 00 22 04 | 01 00 00 00 2a 04 00 00 |......".|....*...|
|00001b20| 00 00 2b 04 00 00 00 00 | 00 04 01 09 4c 41 53 54 |..+.....|....LAST|
|00001b30| 5f 4e 41 4d 45 02 08 4c | 41 53 54 4e 41 4d 45 0d |_NAME..L|ASTNAME.|
|00001b40| 04 02 00 00 00 08 04 25 | 00 00 00 0a 04 14 00 00 |.......%|........|
|00001b50| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 03 |........|........|
|00001b60| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 26 |........|.".....&|
|00001b70| 04 01 00 00 00 2a 04 00 | 00 00 00 00 04 01 06 45 |.....*..|.......E|
|00001b80| 4d 50 5f 4e 4f 02 05 45 | 4d 50 4e 4f 0d 04 00 00 |MP_NO..E|MPNO....|
|00001b90| 00 00 08 04 07 00 00 00 | 0a 04 02 00 00 00 09 04 |........|........|
|00001ba0| 00 00 00 00 0b 04 00 00 | 00 00 16 04 01 00 00 00 |........|........|
|00001bb0| 18 04 00 00 00 00 22 04 | 01 00 00 00 26 04 01 00 |......".|....&...|
|00001bc0| 00 00 00 04 01 09 46 55 | 4c 4c 5f 4e 41 4d 45 02 |......FU|LL_NAME.|
|00001bd0| 05 52 44 42 24 39 0d 04 | 0a 00 00 00 08 04 25 00 |.RDB$9..|......%.|
|00001be0| 00 00 0a 04 25 00 00 00 | 09 04 00 00 00 00 0b 04 |....%...|........|
|00001bf0| 00 00 00 00 16 04 0b 00 | 00 00 18 04 00 00 00 00 |........|........|
|00001c00| 22 04 00 00 00 00 2a 04 | 00 00 00 00 2b 04 00 00 |".....*.|....+...|
|00001c10| 00 00 17 04 01 00 00 00 | 00 04 01 0b 4a 4f 42 5f |........|....JOB_|
|00001c20| 43 4f 55 4e 54 52 59 02 | 0b 43 4f 55 4e 54 52 59 |COUNTRY.|.COUNTRY|
|00001c30| 4e 41 4d 45 0d 04 08 00 | 00 00 08 04 25 00 00 00 |NAME....|....%...|
|00001c40| 0a 04 0f 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001c50| 00 00 16 04 09 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00001c60| 01 00 00 00 26 04 01 00 | 00 00 2a 04 00 00 00 00 |....&...|..*.....|
|00001c70| 00 04 01 08 4a 4f 42 5f | 43 4f 44 45 02 07 4a 4f |....JOB_|CODE..JO|
|00001c80| 42 43 4f 44 45 0d 04 06 | 00 00 00 08 04 25 00 00 |BCODE...|.....%..|
|00001c90| 00 0a 04 05 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00001ca0| 00 00 00 16 04 07 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00001cb0| 04 01 00 00 00 26 04 01 | 00 00 00 2a 04 00 00 00 |.....&..|...*....|
|00001cc0| 00 00 04 01 07 44 45 50 | 54 5f 4e 4f 02 06 44 45 |.....DEP|T_NO..DE|
|00001cd0| 50 54 4e 4f 0d 04 05 00 | 00 00 08 04 0e 00 00 00 |PTNO....|........|
|00001ce0| 0a 04 03 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00001cf0| 00 00 16 04 06 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00001d00| 01 00 00 00 26 04 01 00 | 00 00 2a 04 00 00 00 00 |....&...|..*.....|
|00001d10| 00 04 01 0a 46 49 52 53 | 54 5f 4e 41 4d 45 02 09 |....FIRS|T_NAME..|
|00001d20| 46 49 52 53 54 4e 41 4d | 45 0d 04 01 00 00 00 08 |FIRSTNAM|E.......|
|00001d30| 04 25 00 00 00 0a 04 0f | 00 00 00 09 04 00 00 00 |.%......|........|
|00001d40| 00 0b 04 00 00 00 00 16 | 04 02 00 00 00 18 04 00 |........|........|
|00001d50| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 2a |..."....|.&.....*|
|00001d60| 04 00 00 00 00 00 09 03 | 01 0a 50 48 4f 4e 45 5f |........|..PHONE_|
|00001d70| 4c 49 53 54 02 04 33 00 | 00 00 04 43 02 4a 08 45 |LIST..3.|...C.J.E|
|00001d80| 4d 50 4c 4f 59 45 45 01 | 4a 0a 44 45 50 41 52 54 |MPLOYEE.|J.DEPART|
|00001d90| 4d 45 4e 54 02 47 2f 17 | 01 07 44 45 50 54 5f 4e |MENT.G/.|..DEPT_N|
|00001da0| 4f 17 02 07 44 45 50 54 | 5f 4e 4f ff 4c 10 04 01 |O...DEPT|_NO.L...|
|00001db0| 00 00 00 08 0e 53 51 4c | 24 50 48 4f 4e 45 5f 4c |.....SQL|$PHONE_L|
|00001dc0| 49 53 54 0e 04 97 00 00 | 00 20 53 45 4c 45 43 54 |IST.....|. SELECT|
|00001dd0| 0a 20 20 20 20 65 6d 70 | 5f 6e 6f 2c 20 66 69 72 |.    emp|_no, fir|
|00001de0| 73 74 5f 6e 61 6d 65 2c | 20 6c 61 73 74 5f 6e 61 |st_name,| last_na|
|00001df0| 6d 65 2c 20 70 68 6f 6e | 65 5f 65 78 74 2c 20 6c |me, phon|e_ext, l|
|00001e00| 6f 63 61 74 69 6f 6e 2c | 20 70 68 6f 6e 65 5f 6e |ocation,| phone_n|
|00001e10| 6f 0a 20 20 20 20 46 52 | 4f 4d 20 65 6d 70 6c 6f |o.    FR|OM emplo|
|00001e20| 79 65 65 2c 20 64 65 70 | 61 72 74 6d 65 6e 74 0a |yee, dep|artment.|
|00001e30| 20 20 20 20 57 48 45 52 | 45 20 65 6d 70 6c 6f 79 |    WHER|E employ|
|00001e40| 65 65 2e 64 65 70 74 5f | 6e 6f 20 3d 20 64 65 70 |ee.dept_|no = dep|
|00001e50| 61 72 74 6d 65 6e 74 2e | 64 65 70 74 5f 6e 6f 00 |artment.|dept_no.|
|00001e60| 0c 06 53 59 53 44 42 41 | 00 04 01 08 50 48 4f 4e |..SYSDBA|....PHON|
|00001e70| 45 5f 4e 4f 02 0b 50 48 | 4f 4e 45 4e 55 4d 42 45 |E_NO..PH|ONENUMBE|
|00001e80| 52 0d 04 05 00 00 00 08 | 04 25 00 00 00 0a 04 14 |R.......|.%......|
|00001e90| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00001ea0| 04 06 00 00 00 18 04 00 | 00 00 00 22 04 00 00 00 |........|..."....|
|00001eb0| 00 2a 04 00 00 00 00 04 | 04 02 00 00 00 03 08 50 |.*......|.......P|
|00001ec0| 48 4f 4e 45 5f 4e 4f 00 | 04 01 09 50 48 4f 4e 45 |HONE_NO.|...PHONE|
|00001ed0| 5f 45 58 54 02 05 52 44 | 42 24 37 0d 04 03 00 00 |_EXT..RD|B$7.....|
|00001ee0| 00 08 04 25 00 00 00 0a | 04 04 00 00 00 09 04 00 |...%....|........|
|00001ef0| 00 00 00 0b 04 00 00 00 | 00 16 04 04 00 00 00 18 |........|........|
|00001f00| 04 00 00 00 00 22 04 00 | 00 00 00 2a 04 00 00 00 |....."..|...*....|
|00001f10| 00 04 04 01 00 00 00 03 | 09 50 48 4f 4e 45 5f 45 |........|.PHONE_E|
|00001f20| 58 54 00 04 01 09 4c 41 | 53 54 5f 4e 41 4d 45 02 |XT....LA|ST_NAME.|
|00001f30| 08 4c 41 53 54 4e 41 4d | 45 0d 04 02 00 00 00 08 |.LASTNAM|E.......|
|00001f40| 04 25 00 00 00 0a 04 14 | 00 00 00 09 04 00 00 00 |.%......|........|
|00001f50| 00 0b 04 00 00 00 00 16 | 04 03 00 00 00 18 04 00 |........|........|
|00001f60| 00 00 00 22 04 00 00 00 | 00 2a 04 00 00 00 00 04 |..."....|.*......|
|00001f70| 04 01 00 00 00 03 09 4c | 41 53 54 5f 4e 41 4d 45 |.......L|AST_NAME|
|00001f80| 00 04 01 06 45 4d 50 5f | 4e 4f 02 05 45 4d 50 4e |....EMP_|NO..EMPN|
|00001f90| 4f 0d 04 00 00 00 00 08 | 04 07 00 00 00 0a 04 02 |O.......|........|
|00001fa0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00001fb0| 04 01 00 00 00 18 04 00 | 00 00 00 22 04 00 00 00 |........|..."....|
|00001fc0| 00 04 04 01 00 00 00 03 | 06 45 4d 50 5f 4e 4f 00 |........|.EMP_NO.|
|00001fd0| 04 01 08 4c 4f 43 41 54 | 49 4f 4e 02 05 52 44 42 |...LOCAT|ION..RDB|
|00001fe0| 24 36 0d 04 04 00 00 00 | 08 04 25 00 00 00 0a 04 |$6......|..%.....|
|00001ff0| 0f 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002000| 16 04 05 00 00 00 18 04 | 00 00 00 00 22 04 00 00 |........|...."...|
|00002010| 00 00 2a 04 00 00 00 00 | 04 04 02 00 00 00 03 08 |..*.....|........|
|00002020| 4c 4f 43 41 54 49 4f 4e | 00 04 01 0a 46 49 52 53 |LOCATION|....FIRS|
|00002030| 54 5f 4e 41 4d 45 02 09 | 46 49 52 53 54 4e 41 4d |T_NAME..|FIRSTNAM|
|00002040| 45 0d 04 01 00 00 00 08 | 04 25 00 00 00 0a 04 0f |E.......|.%......|
|00002050| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002060| 04 02 00 00 00 18 04 00 | 00 00 00 22 04 00 00 00 |........|..."....|
|00002070| 00 2a 04 00 00 00 00 04 | 04 01 00 00 00 03 0a 46 |.*......|.......F|
|00002080| 49 52 53 54 5f 4e 41 4d | 45 00 0b 08 0a 44 45 50 |IRST_NAM|E....DEP|
|00002090| 41 52 54 4d 45 4e 54 09 | 04 02 00 00 00 0a 0a 44 |ARTMENT.|.......D|
|000020a0| 45 50 41 52 54 4d 45 4e | 54 00 0b 08 08 45 4d 50 |EPARTMEN|T....EMP|
|000020b0| 4c 4f 59 45 45 09 04 01 | 00 00 00 0a 08 45 4d 50 |LOYEE...|.....EMP|
|000020c0| 4c 4f 59 45 45 00 09 03 | 01 07 50 52 4f 4a 45 43 |LOYEE...|..PROJEC|
|000020d0| 54 10 04 01 00 00 00 08 | 0b 53 51 4c 24 50 52 4f |T.......|.SQL$PRO|
|000020e0| 4a 45 43 54 0c 06 53 59 | 53 44 42 41 00 04 01 09 |JECT..SY|SDBA....|
|000020f0| 50 52 4f 4a 5f 44 45 53 | 43 02 06 52 44 42 24 31 |PROJ_DES|C..RDB$1|
|00002100| 31 0d 04 02 00 00 00 08 | 04 05 01 00 00 0a 04 08 |1.......|........|
|00002110| 00 00 00 09 04 01 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002120| 04 03 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002130| 00 2a 04 00 00 00 00 00 | 04 01 07 50 52 4f 44 55 |.*......|...PRODU|
|00002140| 43 54 02 08 50 52 4f 44 | 54 59 50 45 0d 04 04 00 |CT..PROD|TYPE....|
|00002150| 00 00 08 04 25 00 00 00 | 0a 04 0c 00 00 00 09 04 |....%...|........|
|00002160| 00 00 00 00 0b 04 00 00 | 00 00 16 04 05 00 00 00 |........|........|
|00002170| 18 04 00 00 00 00 22 04 | 01 00 00 00 2a 04 00 00 |......".|....*...|
|00002180| 00 00 00 04 01 0b 54 45 | 41 4d 5f 4c 45 41 44 45 |......TE|AM_LEADE|
|00002190| 52 02 05 45 4d 50 4e 4f | 0d 04 03 00 00 00 08 04 |R..EMPNO|........|
|000021a0| 07 00 00 00 0a 04 02 00 | 00 00 09 04 00 00 00 00 |........|........|
|000021b0| 0b 04 00 00 00 00 16 04 | 04 00 00 00 18 04 00 00 |........|........|
|000021c0| 00 00 22 04 01 00 00 00 | 00 04 01 09 50 52 4f 4a |..".....|....PROJ|
|000021d0| 5f 4e 41 4d 45 02 06 52 | 44 42 24 31 30 0d 04 01 |_NAME..R|DB$10...|
|000021e0| 00 00 00 08 04 25 00 00 | 00 0a 04 14 00 00 00 09 |.....%..|........|
|000021f0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 02 00 00 |........|........|
|00002200| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00002210| 00 00 00 2a 04 00 00 00 | 00 2b 04 00 00 00 00 00 |...*....|.+......|
|00002220| 04 01 07 50 52 4f 4a 5f | 49 44 02 06 50 52 4f 4a |...PROJ_|ID..PROJ|
|00002230| 4e 4f 0d 04 00 00 00 00 | 08 04 0e 00 00 00 0a 04 |NO......|........|
|00002240| 05 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002250| 16 04 01 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002260| 00 00 26 04 01 00 00 00 | 2a 04 00 00 00 00 00 09 |..&.....|*.......|
|00002270| 03 01 08 43 55 53 54 4f | 4d 45 52 10 04 01 00 00 |...CUSTO|MER.....|
|00002280| 00 08 0c 53 51 4c 24 43 | 55 53 54 4f 4d 45 52 0c |...SQL$C|USTOMER.|
|00002290| 06 53 59 53 44 42 41 00 | 04 01 0d 41 44 44 52 45 |.SYSDBA.|...ADDRE|
|000022a0| 53 53 5f 4c 49 4e 45 32 | 02 0b 41 44 44 52 45 53 |SS_LINE2|..ADDRES|
|000022b0| 53 4c 49 4e 45 0d 04 06 | 00 00 00 08 04 25 00 00 |SLINE...|.....%..|
|000022c0| 00 0a 04 1e 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|000022d0| 00 00 00 16 04 07 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|000022e0| 04 01 00 00 00 2a 04 00 | 00 00 00 00 04 01 0d 41 |.....*..|.......A|
|000022f0| 44 44 52 45 53 53 5f 4c | 49 4e 45 31 02 0b 41 44 |DDRESS_L|INE1..AD|
|00002300| 44 52 45 53 53 4c 49 4e | 45 0d 04 05 00 00 00 08 |DRESSLIN|E.......|
|00002310| 04 25 00 00 00 0a 04 1e | 00 00 00 09 04 00 00 00 |.%......|........|
|00002320| 00 0b 04 00 00 00 00 16 | 04 06 00 00 00 18 04 00 |........|........|
|00002330| 00 00 00 22 04 01 00 00 | 00 2a 04 00 00 00 00 00 |..."....|.*......|
|00002340| 04 01 07 43 55 53 54 5f | 4e 4f 02 06 43 55 53 54 |...CUST_|NO..CUST|
|00002350| 4e 4f 0d 04 00 00 00 00 | 08 04 08 00 00 00 0a 04 |NO......|........|
|00002360| 04 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002370| 16 04 01 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002380| 00 00 26 04 01 00 00 00 | 00 04 01 0b 50 4f 53 54 |..&.....|....POST|
|00002390| 41 4c 5f 43 4f 44 45 02 | 06 52 44 42 24 32 31 0d |AL_CODE.|.RDB$21.|
|000023a0| 04 0a 00 00 00 08 04 25 | 00 00 00 0a 04 0c 00 00 |.......%|........|
|000023b0| 00 09 04 00 00 00 00 0b | 04 00 00 00 00 16 04 0b |........|........|
|000023c0| 00 00 00 18 04 00 00 00 | 00 22 04 01 00 00 00 2a |........|.".....*|
|000023d0| 04 00 00 00 00 2b 04 00 | 00 00 00 00 04 01 08 50 |.....+..|.......P|
|000023e0| 48 4f 4e 45 5f 4e 4f 02 | 0b 50 48 4f 4e 45 4e 55 |HONE_NO.|.PHONENU|
|000023f0| 4d 42 45 52 0d 04 04 00 | 00 00 08 04 25 00 00 00 |MBER....|....%...|
|00002400| 0a 04 14 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00002410| 00 00 16 04 05 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00002420| 01 00 00 00 2a 04 00 00 | 00 00 00 04 01 0c 43 4f |....*...|......CO|
|00002430| 4e 54 41 43 54 5f 4c 41 | 53 54 02 08 4c 41 53 54 |NTACT_LA|ST..LAST|
|00002440| 4e 41 4d 45 0d 04 03 00 | 00 00 08 04 25 00 00 00 |NAME....|....%...|
|00002450| 0a 04 14 00 00 00 09 04 | 00 00 00 00 0b 04 00 00 |........|........|
|00002460| 00 00 16 04 04 00 00 00 | 18 04 00 00 00 00 22 04 |........|......".|
|00002470| 01 00 00 00 2a 04 00 00 | 00 00 00 04 01 07 4f 4e |....*...|......ON|
|00002480| 5f 48 4f 4c 44 02 06 52 | 44 42 24 32 32 0d 04 0b |_HOLD..R|DB$22...|
|00002490| 00 00 00 08 04 0e 00 00 | 00 0a 04 01 00 00 00 09 |........|........|
|000024a0| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 0c 00 00 |........|........|
|000024b0| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 2a 04 00 |......."|.....*..|
|000024c0| 00 00 00 2b 04 00 00 00 | 00 0f 04 03 00 00 00 04 |...+....|........|
|000024d0| 2d 4c 27 04 0d 00 00 00 | 44 45 46 41 55 4c 54 20 |-L'.....|DEFAULT |
|000024e0| 4e 55 4c 4c 00 00 04 01 | 07 43 4f 55 4e 54 52 59 |NULL....|.COUNTRY|
|000024f0| 02 0b 43 4f 55 4e 54 52 | 59 4e 41 4d 45 0d 04 09 |..COUNTR|YNAME...|
|00002500| 00 00 00 08 04 25 00 00 | 00 0a 04 0f 00 00 00 09 |.....%..|........|
|00002510| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 0a 00 00 |........|........|
|00002520| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 2a 04 00 |......."|.....*..|
|00002530| 00 00 00 00 04 01 0e 53 | 54 41 54 45 5f 50 52 4f |.......S|TATE_PRO|
|00002540| 56 49 4e 43 45 02 06 52 | 44 42 24 32 30 0d 04 08 |VINCE..R|DB$20...|
|00002550| 00 00 00 08 04 25 00 00 | 00 0a 04 0f 00 00 00 09 |.....%..|........|
|00002560| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 09 00 00 |........|........|
|00002570| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 2a 04 00 |......."|.....*..|
|00002580| 00 00 00 2b 04 00 00 00 | 00 00 04 01 04 43 49 54 |...+....|.....CIT|
|00002590| 59 02 06 52 44 42 24 31 | 39 0d 04 07 00 00 00 08 |Y..RDB$1|9.......|
|000025a0| 04 25 00 00 00 0a 04 19 | 00 00 00 09 04 00 00 00 |.%......|........|
|000025b0| 00 0b 04 00 00 00 00 16 | 04 08 00 00 00 18 04 00 |........|........|
|000025c0| 00 00 00 22 04 01 00 00 | 00 2a 04 00 00 00 00 2b |..."....|.*.....+|
|000025d0| 04 00 00 00 00 00 04 01 | 0d 43 4f 4e 54 41 43 54 |........|.CONTACT|
|000025e0| 5f 46 49 52 53 54 02 09 | 46 49 52 53 54 4e 41 4d |_FIRST..|FIRSTNAM|
|000025f0| 45 0d 04 02 00 00 00 08 | 04 25 00 00 00 0a 04 0f |E.......|.%......|
|00002600| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002610| 04 03 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002620| 00 2a 04 00 00 00 00 00 | 04 01 08 43 55 53 54 4f |.*......|...CUSTO|
|00002630| 4d 45 52 02 06 52 44 42 | 24 31 38 0d 04 01 00 00 |MER..RDB|$18.....|
|00002640| 00 08 04 25 00 00 00 0a | 04 19 00 00 00 09 04 00 |...%....|........|
|00002650| 00 00 00 0b 04 00 00 00 | 00 16 04 02 00 00 00 18 |........|........|
|00002660| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|00002670| 00 2a 04 00 00 00 00 2b | 04 00 00 00 00 00 09 03 |.*.....+|........|
|00002680| 01 05 53 41 4c 45 53 10 | 04 01 00 00 00 08 09 53 |..SALES.|.......S|
|00002690| 51 4c 24 53 41 4c 45 53 | 0c 06 53 59 53 44 42 41 |QL$SALES|..SYSDBA|
|000026a0| 00 04 01 04 41 47 45 44 | 02 06 52 44 42 24 33 31 |....AGED|..RDB$31|
|000026b0| 0d 04 0c 00 00 00 08 04 | 1b 00 00 00 0a 04 08 00 |........|........|
|000026c0| 00 00 09 04 00 00 00 00 | 0b 04 00 00 00 00 16 04 |........|........|
|000026d0| 0d 00 00 00 18 04 00 00 | 00 00 22 04 00 00 00 00 |........|..".....|
|000026e0| 17 04 01 00 00 00 00 04 | 01 0b 44 41 54 45 5f 4e |........|..DATE_N|
|000026f0| 45 45 44 45 44 02 06 52 | 44 42 24 32 36 0d 04 06 |EEDED..R|DB$26...|
|00002700| 00 00 00 08 04 23 00 00 | 00 0a 04 08 00 00 00 09 |.....#..|........|
|00002710| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 07 00 00 |........|........|
|00002720| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 00 04 01 |......."|........|
|00002730| 09 53 48 49 50 5f 44 41 | 54 45 02 06 52 44 42 24 |.SHIP_DA|TE..RDB$|
|00002740| 32 35 0d 04 05 00 00 00 | 08 04 23 00 00 00 0a 04 |25......|..#.....|
|00002750| 08 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002760| 16 04 06 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002770| 00 00 00 04 01 0a 4f 52 | 44 45 52 5f 44 41 54 45 |......OR|DER_DATE|
|00002780| 02 06 52 44 42 24 32 34 | 0d 04 04 00 00 00 08 04 |..RDB$24|........|
|00002790| 23 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |#.......|........|
|000027a0| 0b 04 00 00 00 00 16 04 | 05 00 00 00 18 04 00 00 |........|........|
|000027b0| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 0f 04 |..".....|&.......|
|000027c0| 0b 00 00 00 04 15 0f 7f | 00 03 00 6e 6f 77 4c 27 |........|...nowL'|
|000027d0| 04 0e 00 00 00 44 45 46 | 41 55 4c 54 20 27 6e 6f |.....DEF|AULT 'no|
|000027e0| 77 27 00 00 04 01 09 50 | 4f 5f 4e 55 4d 42 45 52 |w'.....P|O_NUMBER|
|000027f0| 02 08 50 4f 4e 55 4d 42 | 45 52 0d 04 00 00 00 00 |..PONUMB|ER......|
|00002800| 08 04 0e 00 00 00 0a 04 | 08 00 00 00 09 04 00 00 |........|........|
|00002810| 00 00 0b 04 00 00 00 00 | 16 04 01 00 00 00 18 04 |........|........|
|00002820| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00002830| 2a 04 00 00 00 00 00 04 | 01 08 44 49 53 43 4f 55 |*.......|..DISCOU|
|00002840| 4e 54 02 06 52 44 42 24 | 33 30 0d 04 0a 00 00 00 |NT..RDB$|30......|
|00002850| 08 04 0a 00 00 00 0a 04 | 04 00 00 00 09 04 00 00 |........|........|
|00002860| 00 00 0b 04 00 00 00 00 | 16 04 0b 00 00 00 18 04 |........|........|
|00002870| 00 00 00 00 22 04 01 00 | 00 00 26 04 01 00 00 00 |...."...|..&.....|
|00002880| 0f 04 09 00 00 00 04 15 | 08 00 00 00 00 00 4c 27 |........|......L'|
|00002890| 04 0a 00 00 00 44 45 46 | 41 55 4c 54 20 30 00 00 |.....DEF|AULT 0..|
|000028a0| 04 01 0b 54 4f 54 41 4c | 5f 56 41 4c 55 45 02 06 |...TOTAL|_VALUE..|
|000028b0| 52 44 42 24 32 39 0d 04 | 09 00 00 00 08 04 08 00 |RDB$29..|........|
|000028c0| 00 00 0a 04 04 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|000028d0| fe ff ff ff 16 04 0a 00 | 00 00 18 04 00 00 00 00 |........|........|
|000028e0| 22 04 01 00 00 00 26 04 | 01 00 00 00 00 04 01 0b |".....&.|........|
|000028f0| 51 54 59 5f 4f 52 44 45 | 52 45 44 02 06 52 44 42 |QTY_ORDE|RED..RDB|
|00002900| 24 32 38 0d 04 08 00 00 | 00 08 04 08 00 00 00 0a |$28.....|........|
|00002910| 04 04 00 00 00 09 04 00 | 00 00 00 0b 04 00 00 00 |........|........|
|00002920| 00 16 04 09 00 00 00 18 | 04 00 00 00 00 22 04 01 |........|....."..|
|00002930| 00 00 00 26 04 01 00 00 | 00 0f 04 09 00 00 00 04 |...&....|........|
|00002940| 15 08 00 01 00 00 00 4c | 27 04 0a 00 00 00 44 45 |.......L|'.....DE|
|00002950| 46 41 55 4c 54 20 31 00 | 00 04 01 07 43 55 53 54 |FAULT 1.|....CUST|
|00002960| 5f 4e 4f 02 06 43 55 53 | 54 4e 4f 0d 04 01 00 00 |_NO..CUS|TNO.....|
|00002970| 00 08 04 08 00 00 00 0a | 04 04 00 00 00 09 04 00 |........|........|
|00002980| 00 00 00 0b 04 00 00 00 | 00 16 04 02 00 00 00 18 |........|........|
|00002990| 04 00 00 00 00 22 04 01 | 00 00 00 26 04 01 00 00 |....."..|...&....|
|000029a0| 00 00 04 01 09 49 54 45 | 4d 5f 54 59 50 45 02 08 |.....ITE|M_TYPE..|
|000029b0| 50 52 4f 44 54 59 50 45 | 0d 04 0b 00 00 00 08 04 |PRODTYPE|........|
|000029c0| 25 00 00 00 0a 04 0c 00 | 00 00 09 04 00 00 00 00 |%.......|........|
|000029d0| 0b 04 00 00 00 00 16 04 | 0c 00 00 00 18 04 00 00 |........|........|
|000029e0| 00 00 22 04 01 00 00 00 | 2a 04 00 00 00 00 00 04 |..".....|*.......|
|000029f0| 01 09 53 41 4c 45 53 5f | 52 45 50 02 05 45 4d 50 |..SALES_|REP..EMP|
|00002a00| 4e 4f 0d 04 02 00 00 00 | 08 04 07 00 00 00 0a 04 |NO......|........|
|00002a10| 02 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002a20| 16 04 03 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002a30| 00 00 00 04 01 04 50 41 | 49 44 02 06 52 44 42 24 |......PA|ID..RDB$|
|00002a40| 32 37 0d 04 07 00 00 00 | 08 04 0e 00 00 00 0a 04 |27......|........|
|00002a50| 01 00 00 00 09 04 00 00 | 00 00 0b 04 00 00 00 00 |........|........|
|00002a60| 16 04 08 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002a70| 00 00 2a 04 00 00 00 00 | 2b 04 00 00 00 00 0f 04 |..*.....|+.......|
|00002a80| 09 00 00 00 04 15 0f 7f | 00 01 00 6e 4c 27 04 0c |........|...nL'..|
|00002a90| 00 00 00 44 45 46 41 55 | 4c 54 20 27 6e 27 00 00 |...DEFAU|LT 'n'..|
|00002aa0| 04 01 0c 4f 52 44 45 52 | 5f 53 54 41 54 55 53 02 |...ORDER|_STATUS.|
|00002ab0| 06 52 44 42 24 32 33 0d | 04 03 00 00 00 08 04 25 |.RDB$23.|.......%|
|00002ac0| 00 00 00 0a 04 07 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00002ad0| 04 00 00 00 00 16 04 04 | 00 00 00 18 04 00 00 00 |........|........|
|00002ae0| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 2a 04 00 |.".....&|.....*..|
|00002af0| 00 00 00 2b 04 00 00 00 | 00 0f 04 0b 00 00 00 04 |...+....|........|
|00002b00| 15 0f 7f 00 03 00 6e 65 | 77 4c 27 04 0e 00 00 00 |......ne|wL'.....|
|00002b10| 44 45 46 41 55 4c 54 20 | 27 6e 65 77 27 00 00 09 |DEFAULT |'new'...|
|00002b20| 03 01 10 45 4d 50 4c 4f | 59 45 45 5f 50 52 4f 4a |...EMPLO|YEE_PROJ|
|00002b30| 45 43 54 10 04 01 00 00 | 00 08 14 53 51 4c 24 45 |ECT.....|...SQL$E|
|00002b40| 4d 50 4c 4f 59 45 45 5f | 50 52 4f 4a 45 43 54 0c |MPLOYEE_|PROJECT.|
|00002b50| 06 53 59 53 44 42 41 00 | 04 01 06 45 4d 50 5f 4e |.SYSDBA.|...EMP_N|
|00002b60| 4f 02 05 45 4d 50 4e 4f | 0d 04 00 00 00 00 08 04 |O..EMPNO|........|
|00002b70| 07 00 00 00 0a 04 02 00 | 00 00 09 04 00 00 00 00 |........|........|
|00002b80| 0b 04 00 00 00 00 16 04 | 01 00 00 00 18 04 00 00 |........|........|
|00002b90| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 00 04 |..".....|&.......|
|00002ba0| 01 07 50 52 4f 4a 5f 49 | 44 02 06 50 52 4f 4a 4e |..PROJ_I|D..PROJN|
|00002bb0| 4f 0d 04 01 00 00 00 08 | 04 0e 00 00 00 0a 04 05 |O.......|........|
|00002bc0| 00 00 00 09 04 00 00 00 | 00 0b 04 00 00 00 00 16 |........|........|
|00002bd0| 04 02 00 00 00 18 04 00 | 00 00 00 22 04 01 00 00 |........|..."....|
|00002be0| 00 26 04 01 00 00 00 2a | 04 00 00 00 00 00 09 03 |.&.....*|........|
|00002bf0| 01 10 50 52 4f 4a 5f 44 | 45 50 54 5f 42 55 44 47 |..PROJ_D|EPT_BUDG|
|00002c00| 45 54 10 04 01 00 00 00 | 08 14 53 51 4c 24 50 52 |ET......|..SQL$PR|
|00002c10| 4f 4a 5f 44 45 50 54 5f | 42 55 44 47 45 54 0c 06 |OJ_DEPT_|BUDGET..|
|00002c20| 53 59 53 44 42 41 00 04 | 01 10 50 52 4f 4a 45 43 |SYSDBA..|..PROJEC|
|00002c30| 54 45 44 5f 42 55 44 47 | 45 54 02 06 42 55 44 47 |TED_BUDG|ET..BUDG|
|00002c40| 45 54 0d 04 04 00 00 00 | 08 04 1b 00 00 00 0a 04 |ET......|........|
|00002c50| 08 00 00 00 09 04 00 00 | 00 00 0b 04 fe ff ff ff |........|........|
|00002c60| 16 04 05 00 00 00 18 04 | 00 00 00 00 22 04 01 00 |........|...."...|
|00002c70| 00 00 00 04 01 0e 51 55 | 41 52 54 5f 48 45 41 44 |......QU|ART_HEAD|
|00002c80| 5f 43 4e 54 02 06 52 44 | 42 24 31 33 0d 04 03 00 |_CNT..RD|B$13....|
|00002c90| 00 00 08 04 08 00 00 00 | 0a 04 04 00 00 00 09 04 |........|........|
|00002ca0| 00 00 00 00 0b 04 00 00 | 00 00 16 04 04 00 00 00 |........|........|
|00002cb0| 18 04 00 00 00 00 22 04 | 01 00 00 00 1d 04 01 00 |......".|........|
|00002cc0| 00 00 20 04 01 00 00 00 | 21 04 04 00 00 00 00 04 |.. .....|!.......|
|00002cd0| 01 04 59 45 41 52 02 06 | 52 44 42 24 31 32 0d 04 |..YEAR..|RDB$12..|
|00002ce0| 00 00 00 00 08 04 08 00 | 00 00 0a 04 04 00 00 00 |........|........|
|00002cf0| 09 04 00 00 00 00 0b 04 | 00 00 00 00 16 04 01 00 |........|........|
|00002d00| 00 00 18 04 00 00 00 00 | 22 04 01 00 00 00 26 04 |........|".....&.|
|00002d10| 01 00 00 00 00 04 01 07 | 44 45 50 54 5f 4e 4f 02 |........|DEPT_NO.|
|00002d20| 06 44 45 50 54 4e 4f 0d | 04 02 00 00 00 08 04 0e |.DEPTNO.|........|
|00002d30| 00 00 00 0a 04 03 00 00 | 00 09 04 00 00 00 00 0b |........|........|
|00002d40| 04 00 00 00 00 16 04 03 | 00 00 00 18 04 00 00 00 |........|........|
|00002d50| 00 22 04 01 00 00 00 26 | 04 01 00 00 00 2a 04 00 |.".....&|.....*..|
|00002d60| 00 00 00 00 04 01 07 50 | 52 4f 4a 5f 49 44 02 06 |.......P|ROJ_ID..|
|00002d70| 50 52 4f 4a 4e 4f 0d 04 | 01 00 00 00 08 04 0e 00 |PROJNO..|........|
|00002d80| 00 00 0a 04 05 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00002d90| 00 00 00 00 16 04 02 00 | 00 00 18 04 00 00 00 00 |........|........|
|00002da0| 22 04 01 00 00 00 26 04 | 01 00 00 00 2a 04 00 00 |".....&.|....*...|
|00002db0| 00 00 00 09 03 01 0e 53 | 41 4c 41 52 59 5f 48 49 |.......S|ALARY_HI|
|00002dc0| 53 54 4f 52 59 10 04 01 | 00 00 00 08 12 53 51 4c |STORY...|.....SQL|
|00002dd0| 24 53 41 4c 41 52 59 5f | 48 49 53 54 4f 52 59 0c |$SALARY_|HISTORY.|
|00002de0| 06 53 59 53 44 42 41 00 | 04 01 0a 4e 45 57 5f 53 |.SYSDBA.|...NEW_S|
|00002df0| 41 4c 41 52 59 02 06 52 | 44 42 24 31 37 0d 04 05 |ALARY..R|DB$17...|
|00002e00| 00 00 00 08 04 1b 00 00 | 00 0a 04 08 00 00 00 09 |........|........|
|00002e10| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 06 00 00 |........|........|
|00002e20| 00 18 04 00 00 00 00 22 | 04 00 00 00 00 17 04 01 |......."|........|
|00002e30| 00 00 00 00 04 01 0e 50 | 45 52 43 45 4e 54 5f 43 |.......P|ERCENT_C|
|00002e40| 48 41 4e 47 45 02 06 52 | 44 42 24 31 36 0d 04 04 |HANGE..R|DB$16...|
|00002e50| 00 00 00 08 04 1b 00 00 | 00 0a 04 08 00 00 00 09 |........|........|
|00002e60| 04 00 00 00 00 0b 04 00 | 00 00 00 16 04 05 00 00 |........|........|
|00002e70| 00 18 04 00 00 00 00 22 | 04 01 00 00 00 26 04 01 |......."|.....&..|
|00002e80| 00 00 00 0f 04 09 00 00 | 00 04 15 08 00 00 00 00 |........|........|
|00002e90| 00 4c 27 04 0a 00 00 00 | 44 45 46 41 55 4c 54 20 |.L'.....|DEFAULT |
|00002ea0| 30 00 00 04 01 0a 4f 4c | 44 5f 53 41 4c 41 52 59 |0.....OL|D_SALARY|
|00002eb0| 02 06 53 41 4c 41 52 59 | 0d 04 03 00 00 00 08 04 |..SALARY|........|
|00002ec0| 1b 00 00 00 0a 04 08 00 | 00 00 09 04 00 00 00 00 |........|........|
|00002ed0| 0b 04 fe ff ff ff 16 04 | 04 00 00 00 18 04 00 00 |........|........|
|00002ee0| 00 00 22 04 01 00 00 00 | 26 04 01 00 00 00 00 04 |..".....|&.......|
|00002ef0| 01 0b 43 48 41 4e 47 45 | 5f 44 41 54 45 02 06 52 |..CHANGE|_DATE..R|
|00002f00| 44 42 24 31 34 0d 04 01 | 00 00 00 08 04 23 00 00 |DB$14...|.....#..|
|00002f10| 00 0a 04 08 00 00 00 09 | 04 00 00 00 00 0b 04 00 |........|........|
|00002f20| 00 00 00 16 04 02 00 00 | 00 18 04 00 00 00 00 22 |........|......."|
|00002f30| 04 01 00 00 00 26 04 01 | 00 00 00 0f 04 0b 00 00 |.....&..|........|
|00002f40| 00 04 15 0f 7f 00 03 00 | 4e 4f 57 4c 27 04 0e 00 |........|NOWL'...|
|00002f50| 00 00 44 45 46 41 55 4c | 54 20 27 4e 4f 57 27 00 |..DEFAUL|T 'NOW'.|
|00002f60| 00 04 01 0a 55 50 44 41 | 54 45 52 5f 49 44 02 06 |....UPDA|TER_ID..|
|00002f70| 52 44 42 24 31 35 0d 04 | 02 00 00 00 08 04 25 00 |RDB$15..|......%.|
|00002f80| 00 00 0a 04 14 00 00 00 | 09 04 00 00 00 00 0b 04 |........|........|
|00002f90| 00 00 00 00 16 04 03 00 | 00 00 18 04 00 00 00 00 |........|........|
|00002fa0| 22 04 01 00 00 00 26 04 | 01 00 00 00 2a 04 00 00 |".....&.|....*...|
|00002fb0| 00 00 2b 04 00 00 00 00 | 00 04 01 06 45 4d 50 5f |..+.....|....EMP_|
|00002fc0| 4e 4f 02 05 45 4d 50 4e | 4f 0d 04 00 00 00 00 08 |NO..EMPN|O.......|
|00002fd0| 04 07 00 00 00 0a 04 02 | 00 00 00 09 04 00 00 00 |........|........|
|00002fe0| 00 0b 04 00 00 00 00 16 | 04 01 00 00 00 18 04 00 |........|........|
|00002ff0| 00 00 00 22 04 01 00 00 | 00 26 04 01 00 00 00 00 |..."....|.&......|
|00003000| 09 1a 01 0a 45 4d 50 5f | 4e 4f 5f 47 45 4e 02 04 |....EMP_|NO_GEN..|
|00003010| 91 00 00 00 00 1a 01 0b | 43 55 53 54 5f 4e 4f 5f |........|CUST_NO_|
|00003020| 47 45 4e 02 04 f7 03 00 | 00 00 1b 01 0c 47 45 54 |GEN.....|.....GET|
|00003030| 5f 45 4d 50 5f 50 52 4f | 4a 02 04 01 00 00 00 03 |_EMP_PRO|J.......|
|00003040| 04 01 00 00 00 07 04 6f | 00 00 00 0a 42 45 47 49 |.......o|....BEGI|
|00003050| 4e 0a 20 46 4f 52 20 53 | 45 4c 45 43 54 20 70 72 |N. FOR S|ELECT pr|
|00003060| 6f 6a 5f 69 64 0a 20 20 | 46 52 4f 4d 20 65 6d 70 |oj_id.  |FROM emp|
|00003070| 6c 6f 79 65 65 5f 70 72 | 6f 6a 65 63 74 0a 20 20 |loyee_pr|oject.  |
|00003080| 57 48 45 52 45 20 65 6d | 70 5f 6e 6f 20 3d 20 3a |WHERE em|p_no = :|
|00003090| 65 6d 70 5f 6e 6f 0a 20 | 20 49 4e 54 4f 20 3a 70 |emp_no. | INTO :p|
|000030a0| 72 6f 6a 5f 69 64 0a 20 | 44 4f 0a 20 20 53 55 53 |roj_id. |DO.  SUS|
|000030b0| 50 45 4e 44 3b 0a 45 4e | 44 00 08 04 9c 00 00 00 |PEND;.EN|D.......|
|000030c0| 04 02 04 00 02 00 07 00 | 07 00 04 01 03 00 0f 00 |........|........|
|000030d0| 00 05 00 07 00 07 00 0c | 00 02 03 00 00 0f 00 00 |........|........|
|000030e0| 05 00 01 2d 1a 00 00 9b | 11 00 02 02 07 43 01 4a |...-....|.....C.J|
|000030f0| 10 45 4d 50 4c 4f 59 45 | 45 5f 50 52 4f 4a 45 43 |.EMPLOYE|E_PROJEC|
|00003100| 54 00 47 2f 17 00 06 45 | 4d 50 5f 4e 4f 29 00 00 |T.G/...E|MP_NO)..|
|00003110| 00 01 00 ff 02 01 17 00 | 07 50 52 4f 4a 5f 49 44 |........|.PROJ_ID|
|00003120| 1a 00 00 02 0e 01 02 01 | 1a 00 00 29 01 00 00 01 |........|...)....|
|00003130| 00 01 15 07 00 01 00 19 | 01 02 00 ff 9b ff ff ff |........|........|
|00003140| ff ff 0e 01 02 01 1a 00 | 00 29 01 00 00 01 00 01 |........|.)......|
|00003150| 15 07 00 00 00 19 01 02 | 00 ff ff 4c 09 10 53 51 |........|...L..SQ|
|00003160| 4c 24 47 45 54 5f 45 4d | 50 5f 50 52 4f 4a 0a 06 |L$GET_EM|P_PROJ..|
|00003170| 53 59 53 44 42 41 00 1c | 01 06 45 4d 50 5f 4e 4f |SYSDBA..|..EMP_NO|
|00003180| 02 04 00 00 00 00 03 04 | 00 00 00 00 04 06 52 44 |........|......RD|
|00003190| 42 24 33 32 00 1c 01 07 | 50 52 4f 4a 5f 49 44 02 |B$32....|PROJ_ID.|
|000031a0| 04 00 00 00 00 03 04 01 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|000031b0| 24 33 33 00 1d 1b 01 0c | 41 44 44 5f 45 4d 50 5f |$33.....|ADD_EMP_|
|000031c0| 50 52 4f 4a 02 04 02 00 | 00 00 03 04 00 00 00 00 |PROJ....|........|
|000031d0| 07 04 9f 00 00 00 0a 42 | 45 47 49 4e 0a 20 42 45 |.......B|EGIN. BE|
|000031e0| 47 49 4e 0a 20 49 4e 53 | 45 52 54 20 49 4e 54 4f |GIN. INS|ERT INTO|
|000031f0| 20 65 6d 70 6c 6f 79 65 | 65 5f 70 72 6f 6a 65 63 | employe|e_projec|
|00003200| 74 20 28 65 6d 70 5f 6e | 6f 2c 20 70 72 6f 6a 5f |t (emp_n|o, proj_|
|00003210| 69 64 29 20 56 41 4c 55 | 45 53 20 28 3a 65 6d 70 |id) VALU|ES (:emp|
|00003220| 5f 6e 6f 2c 20 3a 70 72 | 6f 6a 5f 69 64 29 3b 0a |_no, :pr|oj_id);.|
|00003230| 20 57 48 45 4e 20 53 51 | 4c 43 4f 44 45 20 2d 35 | WHEN SQ|LCODE -5|
|00003240| 33 30 20 44 4f 0a 20 20 | 45 58 43 45 50 54 49 4f |30 DO.  |EXCEPTIO|
|00003250| 4e 20 75 6e 6b 6e 6f 77 | 6e 5f 65 6d 70 5f 69 64 |N unknow|n_emp_id|
|00003260| 3b 0a 20 45 4e 44 0a 20 | 53 55 53 50 45 4e 44 3b |;. END. |SUSPEND;|
|00003270| 0a 45 4e 44 00 08 04 9d | 00 00 00 04 02 04 00 04 |.END....|........|
|00003280| 00 07 00 07 00 0f 00 00 | 05 00 07 00 04 01 01 00 |........|........|
|00003290| 07 00 0c 00 02 9b 11 00 | 02 02 81 02 02 86 0f 4a |........|.......J|
|000032a0| 10 45 4d 50 4c 4f 59 45 | 45 5f 50 52 4f 4a 45 43 |.EMPLOYE|E_PROJEC|
|000032b0| 54 00 02 01 29 00 00 00 | 01 00 17 00 06 45 4d 50 |T...)...|.....EMP|
|000032c0| 5f 4e 4f 01 29 00 02 00 | 03 00 17 00 07 50 52 4f |_NO.)...|.....PRO|
|000032d0| 4a 5f 49 44 ff 87 ff ff | 82 01 00 01 ee fd 02 86 |J_ID....|........|
|000032e0| 80 02 0e 55 4e 4b 4e 4f | 57 4e 5f 45 4d 50 5f 49 |...UNKNO|WN_EMP_I|
|000032f0| 44 87 ff ff 02 0e 01 02 | 01 15 07 00 01 00 19 01 |D.......|........|
|00003300| 00 00 ff 9b ff ff ff ff | 0e 01 02 01 15 07 00 00 |........|........|
|00003310| 00 19 01 00 00 ff ff 4c | 09 10 53 51 4c 24 41 44 |.......L|..SQL$AD|
|00003320| 44 5f 45 4d 50 5f 50 52 | 4f 4a 0a 06 53 59 53 44 |D_EMP_PR|OJ..SYSD|
|00003330| 42 41 00 1c 01 06 45 4d | 50 5f 4e 4f 02 04 00 00 |BA....EM|P_NO....|
|00003340| 00 00 03 04 00 00 00 00 | 04 06 52 44 42 24 33 34 |........|..RDB$34|
|00003350| 00 1c 01 07 50 52 4f 4a | 5f 49 44 02 04 01 00 00 |....PROJ|_ID.....|
|00003360| 00 03 04 00 00 00 00 04 | 06 52 44 42 24 33 35 00 |........|.RDB$35.|
|00003370| 1d 1b 01 0e 53 55 42 5f | 54 4f 54 5f 42 55 44 47 |....SUB_|TOT_BUDG|
|00003380| 45 54 02 04 01 00 00 00 | 03 04 04 00 00 00 07 04 |ET......|........|
|00003390| bc 00 00 00 0a 42 45 47 | 49 4e 0a 20 53 45 4c 45 |.....BEG|IN. SELE|
|000033a0| 43 54 20 53 55 4d 28 62 | 75 64 67 65 74 29 2c 20 |CT SUM(b|udget), |
|000033b0| 41 56 47 28 62 75 64 67 | 65 74 29 2c 20 4d 49 4e |AVG(budg|et), MIN|
|000033c0| 28 62 75 64 67 65 74 29 | 2c 20 4d 41 58 28 62 75 |(budget)|, MAX(bu|
|000033d0| 64 67 65 74 29 0a 20 20 | 46 52 4f 4d 20 64 65 70 |dget).  |FROM dep|
|000033e0| 61 72 74 6d 65 6e 74 0a | 20 20 57 48 45 52 45 20 |artment.|  WHERE |
|000033f0| 68 65 61 64 5f 64 65 70 | 74 20 3d 20 3a 68 65 61 |head_dep|t = :hea|
|00003400| 64 5f 64 65 70 74 0a 20 | 20 49 4e 54 4f 20 3a 74 |d_dept. | INTO :t|
|00003410| 6f 74 5f 62 75 64 67 65 | 74 2c 20 3a 61 76 67 5f |ot_budge|t, :avg_|
|00003420| 62 75 64 67 65 74 2c 20 | 3a 6d 69 6e 5f 62 75 64 |budget, |:min_bud|
|00003430| 67 65 74 2c 20 3a 6d 61 | 78 5f 62 75 64 67 65 74 |get, :ma|x_budget|
|00003440| 3b 0a 20 53 55 53 50 45 | 4e 44 3b 0a 45 4e 44 00 |;. SUSPE|ND;.END.|
|00003450| 08 04 41 01 00 00 04 02 | 04 00 02 00 0f 00 00 03 |..A.....|........|
|00003460| 00 07 00 04 01 09 00 1b | 07 00 1b 07 00 1b 07 00 |........|........|
|00003470| 1b 07 00 07 00 0c 00 02 | 03 00 00 1b 01 2d 1a 00 |........|.....-..|
|00003480| 00 03 01 00 1b 01 2d 1a | 01 00 03 02 00 1b 01 2d |......-.|.......-|
|00003490| 1a 02 00 03 03 00 1b 01 | 2d 1a 03 00 9b 11 00 02 |........|-.......|
|000034a0| 02 07 7f 43 01 4f 01 43 | 01 4a 0a 44 45 50 41 52 |...C.O.C|.J.DEPAR|
|000034b0| 54 4d 45 4e 54 00 47 2f | 17 00 09 48 45 41 44 5f |TMENT.G/|...HEAD_|
|000034c0| 44 45 50 54 29 00 00 00 | 01 00 ff 4e 00 4d 04 00 |DEPT)...|...N.M..|
|000034d0| 00 00 54 17 00 06 42 55 | 44 47 45 54 01 00 55 17 |..T...BU|DGET..U.|
|000034e0| 00 06 42 55 44 47 45 54 | 02 00 57 17 00 06 42 55 |..BUDGET|..W...BU|
|000034f0| 44 47 45 54 03 00 56 17 | 00 06 42 55 44 47 45 54 |DGET..V.|..BUDGET|
|00003500| ff 02 01 18 01 03 00 1a | 00 00 01 18 01 02 00 1a |........|........|
|00003510| 01 00 01 18 01 01 00 1a | 02 00 01 18 01 00 00 1a |........|........|
|00003520| 03 00 ff 02 0e 01 02 01 | 1a 00 00 29 01 00 00 01 |........|...)....|
|00003530| 00 01 1a 01 00 29 01 02 | 00 03 00 01 1a 02 00 29 |.....)..|.......)|
|00003540| 01 04 00 05 00 01 1a 03 | 00 29 01 06 00 07 00 01 |........|.)......|
|00003550| 15 07 00 01 00 19 01 08 | 00 ff 9b ff ff ff ff 0e |........|........|
|00003560| 01 02 01 1a 00 00 29 01 | 00 00 01 00 01 1a 01 00 |......).|........|
|00003570| 29 01 02 00 03 00 01 1a | 02 00 29 01 04 00 05 00 |).......|..).....|
|00003580| 01 1a 03 00 29 01 06 00 | 07 00 01 15 07 00 00 00 |....)...|........|
|00003590| 19 01 08 00 ff ff 4c 09 | 12 53 51 4c 24 53 55 42 |......L.|.SQL$SUB|
|000035a0| 5f 54 4f 54 5f 42 55 44 | 47 45 54 0a 06 53 59 53 |_TOT_BUD|GET..SYS|
|000035b0| 44 42 41 00 1c 01 09 48 | 45 41 44 5f 44 45 50 54 |DBA....H|EAD_DEPT|
|000035c0| 02 04 00 00 00 00 03 04 | 00 00 00 00 04 06 52 44 |........|......RD|
|000035d0| 42 24 33 36 00 1c 01 0a | 54 4f 54 5f 42 55 44 47 |B$36....|TOT_BUDG|
|000035e0| 45 54 02 04 00 00 00 00 | 03 04 01 00 00 00 04 06 |ET......|........|
|000035f0| 52 44 42 24 33 37 00 1c | 01 0a 41 56 47 5f 42 55 |RDB$37..|..AVG_BU|
|00003600| 44 47 45 54 02 04 01 00 | 00 00 03 04 01 00 00 00 |DGET....|........|
|00003610| 04 06 52 44 42 24 33 38 | 00 1c 01 0a 4d 49 4e 5f |..RDB$38|....MIN_|
|00003620| 42 55 44 47 45 54 02 04 | 02 00 00 00 03 04 01 00 |BUDGET..|........|
|00003630| 00 00 04 06 52 44 42 24 | 33 39 00 1c 01 0a 4d 41 |....RDB$|39....MA|
|00003640| 58 5f 42 55 44 47 45 54 | 02 04 03 00 00 00 03 04 |X_BUDGET|........|
|00003650| 01 00 00 00 04 06 52 44 | 42 24 34 30 00 1d 1b 01 |......RD|B$40....|
|00003660| 0f 44 45 4c 45 54 45 5f | 45 4d 50 4c 4f 59 45 45 |.DELETE_|EMPLOYEE|
|00003670| 02 04 01 00 00 00 03 04 | 00 00 00 00 07 04 cc 03 |........|........|
|00003680| 00 00 0a 20 44 45 43 4c | 41 52 45 20 56 41 52 49 |... DECL|ARE VARI|
|00003690| 41 42 4c 45 20 61 6e 79 | 5f 73 61 6c 65 73 20 49 |ABLE any|_sales I|
|000036a0| 4e 54 45 47 45 52 3b 0a | 42 45 47 49 4e 0a 20 61 |NTEGER;.|BEGIN. a|
|000036b0| 6e 79 5f 73 61 6c 65 73 | 20 3d 20 30 3b 0a 0a 20 |ny_sales| = 0;.. |
|000036c0| 2f 2a 0a 20 20 2a 20 49 | 66 20 74 68 65 72 65 20 |/*.  * I|f there |
|000036d0| 61 72 65 20 61 6e 79 20 | 73 61 6c 65 73 20 72 65 |are any |sales re|
|000036e0| 63 6f 72 64 73 20 72 65 | 66 65 72 65 6e 63 69 6e |cords re|ferencin|
|000036f0| 67 20 74 68 69 73 20 65 | 6d 70 6c 6f 79 65 65 2c |g this e|mployee,|
|00003700| 0a 20 20 2a 20 63 61 6e | 27 74 20 64 65 6c 65 74 |.  * can|'t delet|
|00003710| 65 20 74 68 65 20 65 6d | 70 6c 6f 79 65 65 20 75 |e the em|ployee u|
|00003720| 6e 74 69 6c 20 74 68 65 | 20 73 61 6c 65 73 20 61 |ntil the| sales a|
|00003730| 72 65 20 72 65 2d 61 73 | 73 69 67 6e 65 64 0a 20 |re re-as|signed. |
|00003740| 20 2a 20 74 6f 20 61 6e | 6f 74 68 65 72 20 65 6d | * to an|other em|
|00003750| 70 6c 6f 79 65 65 20 6f | 72 20 63 68 61 6e 67 65 |ployee o|r change|
|00003760| 64 20 74 6f 20 4e 55 4c | 4c 2e 0a 20 20 2a 2f 0a |d to NUL|L..  */.|
|00003770| 20 53 45 4c 45 43 54 20 | 63 6f 75 6e 74 28 70 6f | SELECT |count(po|
|00003780| 5f 6e 75 6d 62 65 72 29 | 0a 20 46 52 4f 4d 20 73 |_number)|. FROM s|
|00003790| 61 6c 65 73 0a 20 57 48 | 45 52 45 20 73 61 6c 65 |ales. WH|ERE sale|
|000037a0| 73 5f 72 65 70 20 3d 20 | 3a 65 6d 70 5f 6e 75 6d |s_rep = |:emp_num|
|000037b0| 0a 20 49 4e 54 4f 20 3a | 61 6e 79 5f 73 61 6c 65 |. INTO :|any_sale|
|000037c0| 73 3b 0a 0a 20 49 46 20 | 28 61 6e 79 5f 73 61 6c |s;.. IF |(any_sal|
|000037d0| 65 73 20 3e 20 30 29 20 | 54 48 45 4e 0a 20 42 45 |es > 0) |THEN. BE|
|000037e0| 47 49 4e 0a 20 20 45 58 | 43 45 50 54 49 4f 4e 20 |GIN.  EX|CEPTION |
|000037f0| 72 65 61 73 73 69 67 6e | 5f 73 61 6c 65 73 3b 0a |reassign|_sales;.|
|00003800| 20 20 53 55 53 50 45 4e | 44 3b 0a 20 45 4e 44 0a |  SUSPEN|D;. END.|
|00003810| 0a 20 2f 2a 0a 20 20 2a | 20 49 66 20 74 68 65 20 |. /*.  *| If the |
|00003820| 65 6d 70 6c 6f 79 65 65 | 20 69 73 20 61 20 6d 61 |employee| is a ma|
|00003830| 6e 61 67 65 72 2c 20 75 | 70 64 61 74 65 20 74 68 |nager, u|pdate th|
|00003840| 65 20 64 65 70 61 72 74 | 6d 65 6e 74 2e 0a 20 20 |e depart|ment..  |
|00003850| 2a 2f 0a 20 55 50 44 41 | 54 45 20 64 65 70 61 72 |*/. UPDA|TE depar|
|00003860| 74 6d 65 6e 74 0a 20 53 | 45 54 20 6d 6e 67 72 5f |tment. S|ET mngr_|
|00003870| 6e 6f 20 3d 20 4e 55 4c | 4c 0a 20 57 48 45 52 45 |no = NUL|L. WHERE|
|00003880| 20 6d 00 6e 67 72 5f 6e | 6f 20 3d 20 3a 65 6d 70 | m.ngr_n|o = :emp|
|00003890| 5f 6e 75 6d 3b 0a 0a 20 | 2f 2a 0a 20 20 2a 20 49 |_num;.. |/*.  * I|
|000038a0| 66 20 74 68 65 20 65 6d | 70 6c 6f 79 65 65 20 69 |f the em|ployee i|
|000038b0| 73 20 61 20 70 72 6f 6a | 65 63 74 20 6c 65 61 64 |s a proj|ect lead|
|000038c0| 65 72 2c 20 75 70 64 61 | 74 65 20 70 72 6f 6a 65 |er, upda|te proje|
|000038d0| 63 74 2e 0a 20 20 2a 2f | 0a 20 55 50 44 41 54 45 |ct..  */|. UPDATE|
|000038e0| 20 70 72 6f 6a 65 63 74 | 0a 20 53 45 54 20 74 65 | project|. SET te|
|000038f0| 61 6d 5f 6c 65 61 64 65 | 72 20 3d 20 4e 55 4c 4c |am_leade|r = NULL|
|00003900| 0a 20 57 48 45 52 45 20 | 74 65 61 6d 5f 6c 65 61 |. WHERE |team_lea|
|00003910| 64 65 72 20 3d 20 3a 65 | 6d 70 5f 6e 75 6d 3b 0a |der = :e|mp_num;.|
|00003920| 0a 20 2f 2a 0a 20 20 2a | 20 44 65 6c 65 74 65 20 |. /*.  *| Delete |
|00003930| 74 68 65 20 65 6d 70 6c | 6f 79 65 65 20 66 72 6f |the empl|oyee fro|
|00003940| 6d 20 61 6e 79 20 70 72 | 6f 6a 65 63 74 73 2e 0a |m any pr|ojects..|
|00003950| 20 20 2a 2f 0a 20 44 45 | 4c 45 54 45 20 46 52 4f |  */. DE|LETE FRO|
|00003960| 4d 20 65 6d 70 6c 6f 79 | 65 65 5f 70 72 6f 6a 65 |M employ|ee_proje|
|00003970| 63 74 0a 20 57 48 45 52 | 45 20 65 6d 70 5f 6e 6f |ct. WHER|E emp_no|
|00003980| 20 3d 20 3a 65 6d 70 5f | 6e 75 6d 3b 0a 0a 20 2f | = :emp_|num;.. /|
|00003990| 2a 0a 20 20 2a 20 44 65 | 6c 65 74 65 20 6f 6c 64 |*.  * De|lete old|
|000039a0| 20 73 61 6c 61 72 79 20 | 72 65 63 6f 72 64 73 2e | salary |records.|
|000039b0| 0a 20 20 2a 2f 0a 20 44 | 45 4c 45 54 45 20 46 52 |.  */. D|ELETE FR|
|000039c0| 4f 4d 20 73 61 6c 61 72 | 79 5f 68 69 73 74 6f 72 |OM salar|y_histor|
|000039d0| 79 0a 20 57 48 45 52 45 | 20 65 6d 70 5f 6e 6f 20 |y. WHERE| emp_no |
|000039e0| 3d 20 3a 65 6d 70 5f 6e | 75 6d 3b 0a 0a 20 2f 2a |= :emp_n|um;.. /*|
|000039f0| 0a 20 20 2a 20 44 65 6c | 65 74 65 20 74 68 65 20 |.  * Del|ete the |
|00003a00| 65 6d 70 6c 6f 79 65 65 | 2e 0a 20 20 2a 2f 0a 20 |employee|..  */. |
|00003a10| 44 45 4c 45 54 45 20 46 | 52 4f 4d 20 65 6d 70 6c |DELETE F|ROM empl|
|00003a20| 6f 79 65 65 0a 20 57 48 | 45 52 45 20 65 6d 70 5f |oyee. WH|ERE emp_|
|00003a30| 6e 6f 20 3d 20 3a 65 6d | 70 5f 6e 75 6d 3b 0a 0a |no = :em|p_num;..|
|00003a40| 20 53 55 53 50 45 4e 44 | 3b 0a 45 4e 44 00 08 04 | SUSPEND|;.END...|
|00003a50| a9 01 00 00 04 02 04 00 | 02 00 08 00 07 00 04 01 |........|........|
|00003a60| 01 00 07 00 0c 00 02 03 | 00 00 08 00 01 2d 1a 00 |........|.....-..|
|00003a70| 00 9b 11 00 02 02 01 15 | 08 00 00 00 00 00 1a 00 |........|........|
|00003a80| 00 07 7f 43 01 4f 01 43 | 01 4a 05 53 41 4c 45 53 |...C.O.C|.J.SALES|
|00003a90| 00 47 2f 17 00 09 53 41 | 4c 45 53 5f 52 45 50 29 |.G/...SA|LES_REP)|
|00003aa0| 00 00 00 01 00 ff 4e 00 | 4d 01 00 00 00 5d 17 00 |......N.|M....]..|
|00003ab0| 09 50 4f 5f 4e 55 4d 42 | 45 52 ff 02 01 18 01 00 |.PO_NUMB|ER......|
|00003ac0| 00 1a 00 00 ff 08 31 1a | 00 00 15 08 00 00 00 00 |......1.|........|
|00003ad0| 00 02 02 80 02 0e 52 45 | 41 53 53 49 47 4e 5f 53 |......RE|ASSIGN_S|
|00003ae0| 41 4c 45 53 02 0e 01 02 | 01 15 07 00 01 00 19 01 |ALES....|........|
|00003af0| 00 00 ff 9b ff ff ff ff | 07 43 01 4a 0a 44 45 50 |........|.C.J.DEP|
|00003b00| 41 52 54 4d 45 4e 54 02 | 47 2f 17 02 07 4d 4e 47 |ARTMENT.|G/...MNG|
|00003b10| 52 5f 4e 4f 29 00 00 00 | 01 00 ff 0a 02 02 02 01 |R_NO)...|........|
|00003b20| 2d 17 02 07 4d 4e 47 52 | 5f 4e 4f ff 07 43 01 4a |-...MNGR|_NO..C.J|
|00003b30| 07 50 52 4f 4a 45 43 54 | 03 47 2f 17 03 0b 54 45 |.PROJECT|.G/...TE|
|00003b40| 41 4d 5f 4c 45 41 44 45 | 52 29 00 00 00 01 00 ff |AM_LEADE|R)......|
|00003b50| 0a 03 03 02 01 2d 17 03 | 0b 54 45 41 4d 5f 4c 45 |.....-..|.TEAM_LE|
|00003b60| 41 44 45 52 ff 07 43 01 | 4a 10 45 4d 50 4c 4f 59 |ADER..C.|J.EMPLOY|
|00003b70| 45 45 5f 50 52 4f 4a 45 | 43 54 04 47 2f 17 04 06 |EE_PROJE|CT.G/...|
|00003b80| 45 4d 50 5f 4e 4f 29 00 | 00 00 01 00 ff 05 04 07 |EMP_NO).|........|
|00003b90| 43 01 4a 0e 53 41 4c 41 | 52 59 5f 48 49 53 54 4f |C.J.SALA|RY_HISTO|
|00003ba0| 52 59 05 47 2f 17 05 06 | 45 4d 50 5f 4e 4f 29 00 |RY.G/...|EMP_NO).|
|00003bb0| 00 00 01 00 ff 05 05 07 | 43 01 4a 08 45 4d 50 4c |........|C.J.EMPL|
|00003bc0| 4f 59 45 45 06 47 2f 17 | 06 06 45 4d 50 5f 4e 4f |OYEE.G/.|..EMP_NO|
|00003bd0| 29 00 00 00 01 00 ff 05 | 06 02 0e 01 02 01 15 07 |).......|........|
|00003be0| 00 01 00 19 01 00 00 ff | 9b ff ff ff ff 0e 01 02 |........|........|
|00003bf0| 01 15 07 00 00 00 19 01 | 00 00 ff ff 4c 09 13 53 |........|....L..S|
|00003c00| 51 4c 24 44 45 4c 45 54 | 45 5f 45 4d 50 4c 4f 59 |QL$DELET|E_EMPLOY|
|00003c10| 45 45 0a 06 53 59 53 44 | 42 41 00 1c 01 07 45 4d |EE..SYSD|BA....EM|
|00003c20| 50 5f 4e 55 4d 02 04 00 | 00 00 00 03 04 00 00 00 |P_NUM...|........|
|00003c30| 00 04 06 52 44 42 24 34 | 31 00 1d 1b 01 0b 44 45 |...RDB$4|1.....DE|
|00003c40| 50 54 5f 42 55 44 47 45 | 54 02 04 01 00 00 00 03 |PT_BUDGE|T.......|
|00003c50| 04 01 00 00 00 07 04 e1 | 01 00 00 0a 20 44 45 43 |........|.... DEC|
|00003c60| 4c 41 52 45 20 56 41 52 | 49 41 42 4c 45 20 73 75 |LARE VAR|IABLE su|
|00003c70| 6d 62 20 44 45 43 49 4d | 41 4c 28 31 32 2c 20 32 |mb DECIM|AL(12, 2|
|00003c80| 29 3b 0a 20 44 45 43 4c | 41 52 45 20 56 41 52 49 |);. DECL|ARE VARI|
|00003c90| 41 42 4c 45 20 72 64 6e | 6f 20 43 48 41 52 28 33 |ABLE rdn|o CHAR(3|
|00003ca0| 29 3b 0a 20 44 45 43 4c | 41 52 45 20 56 41 52 49 |);. DECL|ARE VARI|
|00003cb0| 41 42 4c 45 20 63 6e 74 | 20 49 4e 54 45 47 45 52 |ABLE cnt| INTEGER|
|00003cc0| 3b 0a 42 45 47 49 4e 0a | 20 74 6f 74 20 3d 20 30 |;.BEGIN.| tot = 0|
|00003cd0| 3b 0a 0a 20 53 45 4c 45 | 43 54 20 62 75 64 67 65 |;.. SELE|CT budge|
|00003ce0| 74 20 46 52 4f 4d 20 64 | 65 70 61 72 74 6d 65 6e |t FROM d|epartmen|
|00003cf0| 74 20 57 48 45 52 45 20 | 64 65 70 74 5f 6e 6f 20 |t WHERE |dept_no |
|00003d00| 3d 20 3a 64 6e 6f 20 49 | 4e 54 4f 20 3a 74 6f 74 |= :dno I|NTO :tot|
|00003d10| 3b 0a 0a 20 53 45 4c 45 | 43 54 20 63 6f 75 6e 74 |;.. SELE|CT count|
|00003d20| 28 62 75 64 67 65 74 29 | 20 46 52 4f 4d 20 64 65 |(budget)| FROM de|
|00003d30| 70 61 72 74 6d 65 6e 74 | 20 57 48 45 52 45 20 68 |partment| WHERE h|
|00003d40| 65 61 64 5f 64 65 70 74 | 20 3d 20 3a 64 6e 6f 20 |ead_dept| = :dno |
|00003d50| 49 4e 54 4f 20 3a 63 6e | 74 3b 0a 0a 20 49 46 20 |INTO :cn|t;.. IF |
|00003d60| 28 63 6e 74 20 3d 20 30 | 29 20 54 48 45 4e 0a 20 |(cnt = 0|) THEN. |
|00003d70| 20 53 55 53 50 45 4e 44 | 3b 0a 0a 20 46 4f 52 20 | SUSPEND|;.. FOR |
|00003d80| 53 45 4c 45 43 54 20 64 | 65 70 74 5f 6e 6f 0a 20 |SELECT d|ept_no. |
|00003d90| 20 46 52 4f 4d 20 64 65 | 70 61 72 74 6d 65 6e 74 | FROM de|partment|
|00003da0| 0a 20 20 57 48 45 52 45 | 20 68 65 61 64 5f 64 65 |.  WHERE| head_de|
|00003db0| 70 74 20 3d 20 3a 64 6e | 6f 0a 20 20 49 4e 54 4f |pt = :dn|o.  INTO|
|00003dc0| 20 3a 72 64 6e 6f 0a 20 | 44 4f 0a 20 20 42 45 47 | :rdno. |DO.  BEG|
|00003dd0| 49 4e 0a 20 20 20 45 58 | 45 43 55 54 45 20 50 52 |IN.   EX|ECUTE PR|
|00003de0| 4f 43 45 44 55 52 45 20 | 64 65 70 74 5f 62 75 64 |OCEDURE |dept_bud|
|00003df0| 67 65 74 20 3a 72 64 6e | 6f 20 52 45 54 55 52 4e |get :rdn|o RETURN|
|00003e00| 49 4e 47 5f 56 41 4c 55 | 45 53 20 3a 73 75 6d 62 |ING_VALU|ES :sumb|
|00003e10| 3b 0a 20 20 20 74 6f 74 | 20 3d 20 74 6f 74 20 2b |;.   tot| = tot +|
|00003e20| 20 73 75 6d 62 3b 0a 20 | 20 45 4e 44 0a 0a 20 53 | sumb;. | END.. S|
|00003e30| 55 53 50 45 4e 44 3b 0a | 45 4e 44 00 08 04 86 01 |USPEND;.|END.....|
|00003e40| 00 00 04 02 04 00 02 00 | 0f 00 00 03 00 07 00 04 |........|........|
|00003e50| 01 03 00 1b 07 00 07 00 | 0c 00 02 03 00 00 1b 01 |........|........|
|00003e60| 2d 1a 00 00 03 01 00 1b | 01 2d 1a 01 00 03 02 00 |-.......|.-......|
|00003e70| 0f 00 00 03 00 01 2d 1a | 02 00 03 03 00 08 00 01 |......-.|........|
|00003e80| 2d 1a 03 00 9b 11 00 02 | 02 01 15 08 00 00 00 00 |-.......|........|
|00003e90| 00 1a 00 00 07 7f 43 01 | 4a 0a 44 45 50 41 52 54 |......C.|J.DEPART|
|00003ea0| 4d 45 4e 54 00 47 2f 17 | 00 07 44 45 50 54 5f 4e |MENT.G/.|..DEPT_N|
|00003eb0| 4f 29 00 00 00 01 00 ff | 02 01 17 00 06 42 55 44 |O)......|.....BUD|
|00003ec0| 47 45 54 1a 00 00 ff 07 | 7f 43 01 4f 02 43 01 4a |GET.....|.C.O.C.J|
|00003ed0| 0a 44 45 50 41 52 54 4d | 45 4e 54 01 47 2f 17 01 |.DEPARTM|ENT.G/..|
|00003ee0| 09 48 45 41 44 5f 44 45 | 50 54 29 00 00 00 01 00 |.HEAD_DE|PT).....|
|00003ef0| ff 4e 00 4d 01 00 00 00 | 5d 17 01 06 42 55 44 47 |.N.M....|]...BUDG|
|00003f00| 45 54 ff 02 01 18 02 00 | 00 1a 03 00 ff 08 2f 1a |ET......|....../.|
|00003f10| 03 00 15 08 00 00 00 00 | 00 02 0e 01 02 01 1a 00 |........|........|
|00003f20| 00 29 01 00 00 01 00 01 | 15 07 00 01 00 19 01 02 |.)......|........|
|00003f30| 00 ff 9b ff ff 07 43 01 | 4a 0a 44 45 50 41 52 54 |......C.|J.DEPART|
|00003f40| 4d 45 4e 54 03 47 2f 17 | 03 09 48 45 41 44 5f 44 |MENT.G/.|..HEAD_D|
|00003f50| 45 50 54 29 00 00 00 01 | 00 ff 02 01 17 03 07 44 |EPT)....|.......D|
|00003f60| 45 50 54 5f 4e 4f 1a 02 | 00 02 02 78 0b 44 45 50 |EPT_NO..|...x.DEP|
|00003f70| 54 5f 42 55 44 47 45 54 | 01 00 1a 02 00 01 00 1a |T_BUDGET|........|
|00003f80| 01 00 01 22 1a 00 00 1a | 01 00 1a 00 00 ff ff ff |..."....|........|
|00003f90| 02 0e 01 02 01 1a 00 00 | 29 01 00 00 01 00 01 15 |........|).......|
|00003fa0| 07 00 01 00 19 01 02 00 | ff 9b ff ff ff ff 0e 01 |........|........|
|00003fb0| 02 01 1a 00 00 29 01 00 | 00 01 00 01 15 07 00 00 |.....)..|........|
|00003fc0| 00 19 01 02 00 ff ff 4c | 09 0f 53 51 4c 24 44 45 |.......L|..SQL$DE|
|00003fd0| 50 54 5f 42 55 44 47 45 | 54 0a 06 53 59 53 44 42 |PT_BUDGE|T..SYSDB|
|00003fe0| 41 00 1c 01 03 44 4e 4f | 02 04 00 00 00 00 03 04 |A....DNO|........|
|00003ff0| 00 00 00 00 04 06 52 44 | 42 24 34 32 00 1c 01 03 |......RD|B$42....|
|00004000| 54 4f 54 02 04 00 00 00 | 00 03 04 01 00 00 00 04 |TOT.....|........|
|00004010| 06 52 44 42 24 34 33 00 | 1d 1b 01 09 4f 52 47 5f |.RDB$43.|....ORG_|
|00004020| 43 48 41 52 54 02 04 00 | 00 00 00 03 04 05 00 00 |CHART...|........|
|00004030| 00 07 04 4b 02 00 00 0a | 20 44 45 43 4c 41 52 45 |...K....| DECLARE|
|00004040| 20 56 41 52 49 41 42 4c | 45 20 6d 6e 67 72 5f 6e | VARIABL|E mngr_n|
|00004050| 6f 20 49 4e 54 45 47 45 | 52 3b 0a 20 44 45 43 4c |o INTEGE|R;. DECL|
|00004060| 41 52 45 20 56 41 52 49 | 41 42 4c 45 20 64 6e 6f |ARE VARI|ABLE dno|
|00004070| 20 43 48 41 52 28 33 29 | 3b 0a 42 45 47 49 4e 0a | CHAR(3)|;.BEGIN.|
|00004080| 20 46 4f 52 20 53 45 4c | 45 43 54 20 68 2e 64 65 | FOR SEL|ECT h.de|
|00004090| 70 61 72 74 6d 65 6e 74 | 2c 20 64 2e 64 65 70 61 |partment|, d.depa|
|000040a0| 72 74 6d 65 6e 74 2c 20 | 64 2e 6d 6e 67 72 5f 6e |rtment, |d.mngr_n|
|000040b0| 6f 2c 20 64 2e 64 65 70 | 74 5f 6e 6f 0a 20 20 46 |o, d.dep|t_no.  F|
|000040c0| 52 4f 4d 20 64 65 70 61 | 72 74 6d 65 6e 74 20 64 |ROM depa|rtment d|
|000040d0| 0a 20 20 4c 45 46 54 20 | 4f 55 54 45 52 20 4a 4f |.  LEFT |OUTER JO|
|000040e0| 49 4e 20 64 65 70 61 72 | 74 6d 65 6e 74 20 68 20 |IN depar|tment h |
|000040f0| 4f 4e 20 64 2e 68 65 61 | 64 5f 64 65 70 74 20 3d |ON d.hea|d_dept =|
|00004100| 20 68 2e 64 65 70 74 5f | 6e 6f 0a 20 20 4f 52 44 | h.dept_|no.  ORD|
|00004110| 45 52 20 42 59 20 64 2e | 64 65 70 74 5f 6e 6f 0a |ER BY d.|dept_no.|
|00004120| 20 20 49 4e 54 4f 20 3a | 68 65 61 64 5f 64 65 70 |  INTO :|head_dep|
|00004130| 74 2c 20 3a 64 65 70 61 | 72 74 6d 65 6e 74 2c 20 |t, :depa|rtment, |
|00004140| 3a 6d 6e 67 72 5f 6e 6f | 2c 20 3a 64 6e 6f 0a 20 |:mngr_no|, :dno. |
|00004150| 44 4f 0a 20 42 45 47 49 | 4e 0a 20 20 49 46 20 28 |DO. BEGI|N.  IF (|
|00004160| 3a 6d 6e 67 72 5f 6e 6f | 20 49 53 20 4e 55 4c 4c |:mngr_no| IS NULL|
|00004170| 29 20 54 48 45 4e 0a 20 | 20 42 45 47 49 4e 0a 20 |) THEN. | BEGIN. |
|00004180| 20 20 6d 6e 67 72 5f 6e | 61 6d 65 20 3d 20 22 2d |  mngr_n|ame = "-|
|00004190| 2d 54 42 48 2d 2d 22 3b | 0a 20 20 20 74 69 74 6c |-TBH--";|.   titl|
|000041a0| 65 20 3d 20 22 22 3b 0a | 20 20 45 4e 44 0a 0a 20 |e = "";.|  END.. |
|000041b0| 20 45 4c 53 45 0a 20 20 | 20 53 45 4c 45 43 54 20 | ELSE.  | SELECT |
|000041c0| 66 75 6c 6c 5f 6e 61 6d | 65 2c 20 6a 6f 62 5f 63 |full_nam|e, job_c|
|000041d0| 6f 64 65 0a 20 20 20 46 | 52 4f 4d 20 65 6d 70 6c |ode.   F|ROM empl|
|000041e0| 6f 79 65 65 0a 20 20 20 | 57 48 45 52 45 20 65 6d |oyee.   |WHERE em|
|000041f0| 70 5f 6e 6f 20 3d 20 3a | 6d 6e 67 72 5f 6e 6f 0a |p_no = :|mngr_no.|
|00004200| 20 20 20 49 4e 54 4f 20 | 3a 6d 6e 67 72 5f 6e 61 |   INTO |:mngr_na|
|00004210| 6d 65 2c 20 3a 74 69 74 | 6c 65 3b 0a 0a 20 20 53 |me, :tit|le;..  S|
|00004220| 45 4c 45 43 54 20 43 4f | 55 4e 54 28 65 6d 70 5f |ELECT CO|UNT(emp_|
|00004230| 6e 6f 29 0a 20 20 46 00 | 52 4f 4d 20 65 6d 70 6c |no).  F.|ROM empl|
|00004240| 6f 79 65 65 0a 20 20 57 | 48 45 52 45 20 64 65 70 |oyee.  W|HERE dep|
|00004250| 74 5f 6e 6f 20 3d 20 3a | 64 6e 6f 0a 20 20 49 4e |t_no = :|dno.  IN|
|00004260| 54 4f 20 3a 65 6d 70 5f | 63 6e 74 3b 0a 0a 20 20 |TO :emp_|cnt;..  |
|00004270| 53 55 53 50 45 4e 44 3b | 0a 20 45 4e 44 0a 45 4e |SUSPEND;|. END.EN|
|00004280| 44 00 08 04 3d 02 00 00 | 04 02 04 01 0b 00 0f 00 |D...=...|........|
|00004290| 00 19 00 07 00 0f 00 00 | 19 00 07 00 0f 00 00 14 |........|........|
|000042a0| 00 07 00 0f 00 00 05 00 | 07 00 08 00 07 00 07 00 |........|........|
|000042b0| 02 03 00 00 0f 00 00 19 | 00 01 2d 1a 00 00 03 01 |........|..-.....|
|000042c0| 00 0f 00 00 19 00 01 2d | 1a 01 00 03 02 00 0f 00 |.......-|........|
|000042d0| 00 14 00 01 2d 1a 02 00 | 03 03 00 0f 00 00 05 00 |....-...|........|
|000042e0| 01 2d 1a 03 00 03 04 00 | 08 00 01 2d 1a 04 00 03 |.-......|...-....|
|000042f0| 05 00 08 00 01 2d 1a 05 | 00 03 06 00 0f 00 00 03 |.....-..|........|
|00004300| 00 01 2d 1a 06 00 9b 11 | 00 02 02 07 43 01 77 02 |..-.....|....C.w.|
|00004310| 92 0a 44 45 50 41 52 54 | 4d 45 4e 54 01 44 00 92 |..DEPART|MENT.D..|
|00004320| 0a 44 45 50 41 52 54 4d | 45 4e 54 01 48 01 50 01 |.DEPARTM|ENT.H.P.|
|00004330| 47 2f 17 00 09 48 45 41 | 44 5f 44 45 50 54 17 01 |G/...HEA|D_DEPT..|
|00004340| 07 44 45 50 54 5f 4e 4f | ff 46 01 48 17 00 07 44 |.DEPT_NO|.F.H...D|
|00004350| 45 50 54 5f 4e 4f ff 02 | 01 17 01 0a 44 45 50 41 |EPT_NO..|....DEPA|
|00004360| 52 54 4d 45 4e 54 1a 00 | 00 01 17 00 0a 44 45 50 |RTMENT..|.....DEP|
|00004370| 41 52 54 4d 45 4e 54 1a | 01 00 01 17 00 07 4d 4e |ARTMENT.|......MN|
|00004380| 47 52 5f 4e 4f 1a 05 00 | 01 17 00 07 44 45 50 54 |GR_NO...|....DEPT|
|00004390| 5f 4e 4f 1a 06 00 02 02 | 08 3d 1a 05 00 02 02 01 |_NO.....|.=......|
|000043a0| 15 0f 7f 00 07 00 2d 2d | 54 42 48 2d 2d 1a 02 00 |......--|TBH--...|
|000043b0| 01 15 0f 7f 00 00 00 1a | 03 00 ff ff 07 7f 43 01 |........|......C.|
|000043c0| 4a 08 45 4d 50 4c 4f 59 | 45 45 02 47 2f 17 02 06 |J.EMPLOY|EE.G/...|
|000043d0| 45 4d 50 5f 4e 4f 1a 05 | 00 ff 02 01 17 02 09 46 |EMP_NO..|.......F|
|000043e0| 55 4c 4c 5f 4e 41 4d 45 | 1a 02 00 01 17 02 08 4a |ULL_NAME|.......J|
|000043f0| 4f 42 5f 43 4f 44 45 1a | 03 00 ff 07 7f 43 01 4f |OB_CODE.|.....C.O|
|00004400| 04 43 01 4a 08 45 4d 50 | 4c 4f 59 45 45 03 47 2f |.C.J.EMP|LOYEE.G/|
|00004410| 17 03 07 44 45 50 54 5f | 4e 4f 1a 06 00 ff 4e 00 |...DEPT_|NO....N.|
|00004420| 4d 01 00 00 00 5d 17 03 | 06 45 4d 50 5f 4e 4f ff |M....]..|.EMP_NO.|
|00004430| 02 01 18 04 00 00 1a 04 | 00 ff 02 0e 01 02 01 1a |........|........|
|00004440| 00 00 29 01 00 00 01 00 | 01 1a 01 00 29 01 02 00 |..).....|....)...|
|00004450| 03 00 01 1a 02 00 29 01 | 04 00 05 00 01 1a 03 00 |......).|........|
|00004460| 29 01 06 00 07 00 01 1a | 04 00 29 01 08 00 09 00 |).......|..).....|
|00004470| 01 15 07 00 01 00 19 01 | 0a 00 ff 9b ff ff ff ff |........|........|
|00004480| ff ff ff 0e 01 02 01 1a | 00 00 29 01 00 00 01 00 |........|..).....|
|00004490| 01 1a 01 00 29 01 02 00 | 03 00 01 1a 02 00 29 01 |....)...|......).|
|000044a0| 04 00 05 00 01 1a 03 00 | 29 01 06 00 07 00 01 1a |........|).......|
|000044b0| 04 00 29 01 08 00 09 00 | 01 15 07 00 00 00 19 01 |..).....|........|
|000044c0| 0a 00 ff ff 4c 09 0d 53 | 51 4c 24 4f 52 47 5f 43 |....L..S|QL$ORG_C|
|000044d0| 48 41 52 54 0a 06 53 59 | 53 44 42 41 00 1c 01 09 |HART..SY|SDBA....|
|000044e0| 48 45 41 44 5f 44 45 50 | 54 02 04 00 00 00 00 03 |HEAD_DEP|T.......|
|000044f0| 04 01 00 00 00 04 06 52 | 44 42 24 34 34 00 1c 01 |.......R|DB$44...|
|00004500| 0a 44 45 50 41 52 54 4d | 45 4e 54 02 04 01 00 00 |.DEPARTM|ENT.....|
|00004510| 00 03 04 01 00 00 00 04 | 06 52 44 42 24 34 35 00 |........|.RDB$45.|
|00004520| 1c 01 09 4d 4e 47 52 5f | 4e 41 4d 45 02 04 02 00 |...MNGR_|NAME....|
|00004530| 00 00 03 04 01 00 00 00 | 04 06 52 44 42 24 34 36 |........|..RDB$46|
|00004540| 00 1c 01 05 54 49 54 4c | 45 02 04 03 00 00 00 03 |....TITL|E.......|
|00004550| 04 01 00 00 00 04 06 52 | 44 42 24 34 37 00 1c 01 |.......R|DB$47...|
|00004560| 07 45 4d 50 5f 43 4e 54 | 02 04 04 00 00 00 03 04 |.EMP_CNT|........|
|00004570| 01 00 00 00 04 06 52 44 | 42 24 34 38 00 1d 1b 01 |......RD|B$48....|
|00004580| 0a 4d 41 49 4c 5f 4c 41 | 42 45 4c 02 04 01 00 00 |.MAIL_LA|BEL.....|
|00004590| 00 03 04 06 00 00 00 07 | 04 f8 04 00 00 0a 20 44 |........|...... D|
|000045a0| 45 43 4c 41 52 45 20 56 | 41 52 49 41 42 4c 45 20 |ECLARE V|ARIABLE |
|000045b0| 63 75 73 74 6f 6d 65 72 | 20 56 41 52 43 48 41 52 |customer| VARCHAR|
|000045c0| 28 32 35 29 3b 0a 20 44 | 45 43 4c 41 52 45 20 56 |(25);. D|ECLARE V|
|000045d0| 41 52 49 41 42 4c 45 20 | 66 69 72 73 74 20 20 56 |ARIABLE |first  V|
|000045e0| 41 52 43 48 41 52 28 31 | 35 29 3b 0a 20 44 45 43 |ARCHAR(1|5);. DEC|
|000045f0| 4c 41 52 45 20 56 41 52 | 49 41 42 4c 45 20 6c 61 |LARE VAR|IABLE la|
|00004600| 73 74 20 20 56 41 52 43 | 48 41 52 28 32 30 29 3b |st  VARC|HAR(20);|
|00004610| 0a 20 44 45 43 4c 41 52 | 45 20 56 41 52 49 41 42 |. DECLAR|E VARIAB|
|00004620| 4c 45 20 61 64 64 72 31 | 20 20 56 41 52 43 48 41 |LE addr1|  VARCHA|
|00004630| 52 28 33 30 29 3b 0a 20 | 44 45 43 4c 41 52 45 20 |R(30);. |DECLARE |
|00004640| 56 41 52 49 41 42 4c 45 | 20 61 64 64 72 32 20 20 |VARIABLE| addr2  |
|00004650| 56 41 52 43 48 41 52 28 | 33 30 29 3b 0a 20 44 45 |VARCHAR(|30);. DE|
|00004660| 43 4c 41 52 45 20 56 41 | 52 49 41 42 4c 45 20 63 |CLARE VA|RIABLE c|
|00004670| 69 74 79 20 20 56 41 52 | 43 48 41 52 28 32 35 29 |ity  VAR|CHAR(25)|
|00004680| 3b 0a 20 44 45 43 4c 41 | 52 45 20 56 41 52 49 41 |;. DECLA|RE VARIA|
|00004690| 42 4c 45 20 73 74 61 74 | 65 20 20 56 41 52 43 48 |BLE stat|e  VARCH|
|000046a0| 41 52 28 31 35 29 3b 0a | 20 44 45 43 4c 41 52 45 |AR(15);.| DECLARE|
|000046b0| 20 56 41 52 49 41 42 4c | 45 20 63 6f 75 6e 74 72 | VARIABL|E countr|
|000046c0| 79 20 56 41 52 43 48 41 | 52 28 31 35 29 3b 0a 20 |y VARCHA|R(15);. |
|000046d0| 44 45 43 4c 41 52 45 20 | 56 41 52 49 41 42 4c 45 |DECLARE |VARIABLE|
|000046e0| 20 70 6f 73 74 63 6f 64 | 65 20 56 41 52 43 48 41 | postcod|e VARCHA|
|000046f0| 52 28 31 32 29 3b 0a 20 | 44 45 43 4c 41 52 45 20 |R(12);. |DECLARE |
|00004700| 56 41 52 49 41 42 4c 45 | 20 63 6e 74 20 20 49 4e |VARIABLE| cnt  IN|
|00004710| 54 45 47 45 52 3b 0a 42 | 45 47 49 4e 0a 20 6c 69 |TEGER;.B|EGIN. li|
|00004720| 6e 65 31 20 3d 20 22 22 | 3b 0a 20 6c 69 6e 65 32 |ne1 = ""|;. line2|
|00004730| 20 3d 20 22 22 3b 0a 20 | 6c 69 6e 65 33 20 3d 20 | = "";. |line3 = |
|00004740| 22 22 3b 0a 20 6c 69 6e | 65 34 20 3d 20 22 22 3b |"";. lin|e4 = "";|
|00004750| 0a 20 6c 69 6e 65 35 20 | 3d 20 22 22 3b 0a 20 6c |. line5 |= "";. l|
|00004760| 69 6e 65 36 20 3d 20 22 | 22 3b 0a 0a 20 53 45 4c |ine6 = "|";.. SEL|
|00004770| 45 43 54 20 63 75 73 74 | 6f 6d 65 72 2c 20 63 6f |ECT cust|omer, co|
|00004780| 6e 74 61 63 74 5f 66 69 | 72 73 74 2c 20 63 6f 6e |ntact_fi|rst, con|
|00004790| 74 61 63 74 5f 6c 61 73 | 74 2c 20 61 64 00 64 72 |tact_las|t, ad.dr|
|000047a0| 65 73 73 5f 6c 69 6e 65 | 31 2c 0a 20 20 61 64 64 |ess_line|1,.  add|
|000047b0| 72 65 73 73 5f 6c 69 6e | 65 32 2c 20 63 69 74 79 |ress_lin|e2, city|
|000047c0| 2c 20 73 74 61 74 65 5f | 70 72 6f 76 69 6e 63 65 |, state_|province|
|000047d0| 2c 20 63 6f 75 6e 74 72 | 79 2c 20 70 6f 73 74 61 |, countr|y, posta|
|000047e0| 6c 5f 63 6f 64 65 0a 20 | 46 52 4f 4d 20 43 55 53 |l_code. |FROM CUS|
|000047f0| 54 4f 4d 45 52 0a 20 57 | 48 45 52 45 20 63 75 73 |TOMER. W|HERE cus|
|00004800| 74 5f 6e 6f 20 3d 20 3a | 63 75 73 74 5f 6e 6f 0a |t_no = :|cust_no.|
|00004810| 20 49 4e 54 4f 20 3a 63 | 75 73 74 6f 6d 65 72 2c | INTO :c|ustomer,|
|00004820| 20 3a 66 69 72 73 74 2c | 20 3a 6c 61 73 74 2c 20 | :first,| :last, |
|00004830| 3a 61 64 64 72 31 2c 20 | 3a 61 64 64 72 32 2c 0a |:addr1, |:addr2,.|
|00004840| 20 20 3a 63 69 74 79 2c | 20 3a 73 74 61 74 65 2c |  :city,| :state,|
|00004850| 20 3a 63 6f 75 6e 74 72 | 79 2c 20 3a 70 6f 73 74 | :countr|y, :post|
|00004860| 63 6f 64 65 3b 0a 0a 20 | 49 46 20 28 63 75 73 74 |code;.. |IF (cust|
|00004870| 6f 6d 65 72 20 49 53 20 | 4e 4f 54 20 4e 55 4c 4c |omer IS |NOT NULL|
|00004880| 29 20 54 48 45 4e 0a 20 | 20 6c 69 6e 65 31 20 3d |) THEN. | line1 =|
|00004890| 20 63 75 73 74 6f 6d 65 | 72 3b 0a 20 49 46 20 28 | custome|r;. IF (|
|000048a0| 66 69 72 73 74 20 49 53 | 20 4e 4f 54 20 4e 55 4c |first IS| NOT NUL|
|000048b0| 4c 29 20 54 48 45 4e 0a | 20 20 6c 69 6e 65 32 20 |L) THEN.|  line2 |
|000048c0| 3d 20 66 69 72 73 74 20 | 7c 7c 20 22 20 22 20 7c |= first ||| " " ||
|000048d0| 7c 20 6c 61 73 74 3b 0a | 20 45 4c 53 45 0a 20 20 || last;.| ELSE.  |
|000048e0| 6c 69 6e 65 32 20 3d 20 | 6c 61 73 74 3b 0a 20 49 |line2 = |last;. I|
|000048f0| 46 20 28 61 64 64 72 31 | 20 49 53 20 4e 4f 54 20 |F (addr1| IS NOT |
|00004900| 4e 55 4c 4c 29 20 54 48 | 45 4e 0a 20 20 6c 69 6e |NULL) TH|EN.  lin|
|00004910| 65 33 20 3d 20 61 64 64 | 72 31 3b 0a 20 49 46 20 |e3 = add|r1;. IF |
|00004920| 28 61 64 64 72 32 20 49 | 53 20 4e 4f 54 20 4e 55 |(addr2 I|S NOT NU|
|00004930| 4c 4c 29 20 54 48 45 4e | 0a 20 20 6c 69 6e 65 34 |LL) THEN|.  line4|
|00004940| 20 3d 20 61 64 64 72 32 | 3b 0a 0a 20 49 46 20 28 | = addr2|;.. IF (|
|00004950| 63 6f 75 6e 74 72 79 20 | 3d 20 22 55 53 41 22 29 |country |= "USA")|
|00004960| 20 54 48 45 4e 0a 20 42 | 45 47 49 4e 0a 20 20 49 | THEN. B|EGIN.  I|
|00004970| 46 20 28 63 69 74 79 20 | 49 53 20 4e 4f 54 20 4e |F (city |IS NOT N|
|00004980| 55 4c 4c 29 20 54 48 45 | 4e 0a 20 20 20 6c 69 6e |ULL) THE|N.   lin|
|00004990| 65 35 20 3d 20 63 69 74 | 79 20 7c 7c 20 22 00 2c |e5 = cit|y || ".,|
|000049a0| 20 22 20 7c 7c 20 73 74 | 61 74 65 20 7c 7c 20 22 | " || st|ate || "|
|000049b0| 20 20 22 20 7c 7c 20 70 | 6f 73 74 63 6f 64 65 3b |  " || p|ostcode;|
|000049c0| 0a 20 20 45 4c 53 45 0a | 20 20 20 6c 69 6e 65 35 |.  ELSE.|   line5|
|000049d0| 20 3d 20 73 74 61 74 65 | 20 7c 7c 20 22 20 20 22 | = state| || "  "|
|000049e0| 20 7c 7c 20 70 6f 73 74 | 63 6f 64 65 3b 0a 20 45 | || post|code;. E|
|000049f0| 4e 44 0a 20 45 4c 53 45 | 0a 20 42 45 47 49 4e 0a |ND. ELSE|. BEGIN.|
|00004a00| 20 20 49 46 20 28 63 69 | 74 79 20 49 53 20 4e 4f |  IF (ci|ty IS NO|
|00004a10| 54 20 4e 55 4c 4c 29 20 | 54 48 45 4e 0a 20 20 20 |T NULL) |THEN.   |
|00004a20| 6c 69 6e 65 35 20 3d 20 | 63 69 74 79 20 7c 7c 20 |line5 = |city || |
|00004a30| 22 2c 20 22 20 7c 7c 20 | 73 74 61 74 65 3b 0a 20 |", " || |state;. |
|00004a40| 20 45 4c 53 45 0a 20 20 | 20 6c 69 6e 65 35 20 3d | ELSE.  | line5 =|
|00004a50| 20 73 74 61 74 65 3b 0a | 20 20 6c 69 6e 65 36 20 | state;.|  line6 |
|00004a60| 3d 20 63 6f 75 6e 74 72 | 79 20 7c 7c 20 22 20 20 |= countr|y || "  |
|00004a70| 20 20 22 20 7c 7c 20 70 | 6f 73 74 63 6f 64 65 3b |  " || p|ostcode;|
|00004a80| 0a 20 45 4e 44 0a 0a 20 | 53 55 53 50 45 4e 44 3b |. END.. |SUSPEND;|
|00004a90| 0a 45 4e 44 00 08 04 7b | 03 00 00 04 02 04 00 02 |.END...{|........|
|00004aa0| 00 08 00 07 00 04 01 0d | 00 0f 00 00 28 00 07 00 |........|....(...|
|00004ab0| 0f 00 00 28 00 07 00 0f | 00 00 28 00 07 00 0f 00 |...(....|..(.....|
|00004ac0| 00 28 00 07 00 0f 00 00 | 28 00 07 00 0f 00 00 28 |.(......|(......(|
|00004ad0| 00 07 00 07 00 0c 00 02 | 03 00 00 0f 00 00 28 00 |........|......(.|
|00004ae0| 01 2d 1a 00 00 03 01 00 | 0f 00 00 28 00 01 2d 1a |.-......|...(..-.|
|00004af0| 01 00 03 02 00 0f 00 00 | 28 00 01 2d 1a 02 00 03 |........|(..-....|
|00004b00| 03 00 0f 00 00 28 00 01 | 2d 1a 03 00 03 04 00 0f |.....(..|-.......|
|00004b10| 00 00 28 00 01 2d 1a 04 | 00 03 05 00 0f 00 00 28 |..(..-..|.......(|
|00004b20| 00 01 2d 1a 05 00 03 06 | 00 26 00 00 19 00 01 2d |..-.....|.&.....-|
|00004b30| 1a 06 00 03 07 00 26 00 | 00 0f 00 01 2d 1a 07 00 |......&.|....-...|
|00004b40| 03 08 00 26 00 00 14 00 | 01 2d 1a 08 00 03 09 00 |...&....|.-......|
|00004b50| 26 00 00 1e 00 01 2d 1a | 09 00 03 0a 00 26 00 00 |&.....-.|.....&..|
|00004b60| 1e 00 01 2d 1a 0a 00 03 | 0b 00 26 00 00 19 00 01 |...-....|..&.....|
|00004b70| 2d 1a 0b 00 03 0c 00 26 | 00 00 0f 00 01 2d 1a 0c |-......&|.....-..|
|00004b80| 00 03 0d 00 26 00 00 0f | 00 01 2d 1a 0d 00 03 0e |....&...|..-.....|
|00004b90| 00 26 00 00 0c 00 01 2d | 1a 0e 00 03 0f 00 08 00 |.&.....-|........|
|00004ba0| 01 2d 1a 0f 00 9b 11 00 | 02 02 01 15 0f 7f 00 00 |.-......|........|
|00004bb0| 00 1a 00 00 01 15 0f 7f | 00 00 00 1a 01 00 01 15 |........|........|
|00004bc0| 0f 7f 00 00 00 1a 02 00 | 01 15 0f 7f 00 00 00 1a |........|........|
|00004bd0| 03 00 01 15 0f 7f 00 00 | 00 1a 04 00 01 15 0f 7f |........|........|
|00004be0| 00 00 00 1a 05 00 07 7f | 43 01 4a 08 43 55 53 54 |........|C.J.CUST|
|00004bf0| 4f 4d 45 52 00 47 2f 17 | 00 07 43 55 53 54 5f 4e |OMER.G/.|..CUST_N|
|00004c00| 4f 29 00 00 00 01 00 ff | 02 01 17 00 08 43 55 53 |O)......|.....CUS|
|00004c10| 54 4f 4d 45 52 1a 06 00 | 01 17 00 0d 43 4f 4e 54 |TOMER...|....CONT|
|00004c20| 41 43 54 5f 46 49 52 53 | 54 1a 07 00 01 17 00 0c |ACT_FIRS|T.......|
|00004c30| 43 4f 4e 54 41 43 54 5f | 4c 41 53 54 1a 08 00 01 |CONTACT_|LAST....|
|00004c40| 17 00 0d 41 44 44 52 45 | 53 53 5f 4c 49 4e 45 31 |...ADDRE|SS_LINE1|
|00004c50| 1a 09 00 01 17 00 0d 41 | 44 44 52 45 53 53 5f 4c |.......A|DDRESS_L|
|00004c60| 49 4e 45 32 1a 0a 00 01 | 17 00 04 43 49 54 59 1a |INE2....|...CITY.|
|00004c70| 0b 00 01 17 00 0e 53 54 | 41 54 45 5f 50 52 4f 56 |......ST|ATE_PROV|
|00004c80| 49 4e 43 45 1a 0c 00 01 | 17 00 07 43 4f 55 4e 54 |INCE....|...COUNT|
|00004c90| 52 59 1a 0d 00 01 17 00 | 0b 50 4f 53 54 41 4c 5f |RY......|.POSTAL_|
|00004ca0| 43 4f 44 45 1a 0e 00 ff | 08 3b 3d 1a 06 00 01 1a |CODE....|.;=.....|
|00004cb0| 06 00 1a 00 00 ff 08 3b | 3d 1a 07 00 01 27 27 1a |.......;|=....''.|
|00004cc0| 07 00 15 0f 7f 00 01 00 | 20 1a 08 00 1a 01 00 01 |........| .......|
|00004cd0| 1a 08 00 1a 01 00 08 3b | 3d 1a 09 00 01 1a 09 00 |.......;|=.......|
|00004ce0| 1a 02 00 ff 08 3b 3d 1a | 0a 00 01 1a 0a 00 1a 03 |.....;=.|........|
|00004cf0| 00 ff 08 2f 1a 0d 00 15 | 0f 7f 00 03 00 55 53 41 |.../....|.....USA|
|00004d00| 02 02 08 3b 3d 1a 0b 00 | 01 27 27 27 27 1a 0b 00 |...;=...|.''''...|
|00004d10| 15 0f 7f 00 02 00 2c 20 | 1a 0c 00 15 0f 7f 00 02 |......, |........|
|00004d20| 00 20 20 1a 0e 00 1a 04 | 00 01 27 27 1a 0c 00 15 |.  .....|..''....|
|00004d30| 0f 7f 00 02 00 20 20 1a | 0e 00 1a 04 00 ff ff 02 |.....  .|........|
|00004d40| 02 08 3b 3d 1a 0b 00 01 | 27 27 1a 0b 00 15 0f 7f |..;=....|''......|
|00004d50| 00 02 00 2c 20 1a 0c 00 | 1a 04 00 01 1a 0c 00 1a |..., ...|........|
|00004d60| 04 00 01 27 27 1a 0d 00 | 15 0f 7f 00 04 00 20 20 |...''...|......  |
|00004d70| 20 20 1a 0e 00 1a 05 00 | ff ff 02 0e 01 02 01 1a |  ......|........|
|00004d80| 00 00 29 01 00 00 01 00 | 01 1a 01 00 29 01 02 00 |..).....|....)...|
|00004d90| 03 00 01 1a 02 00 29 01 | 04 00 05 00 01 1a 03 00 |......).|........|
|00004da0| 29 01 06 00 07 00 01 1a | 04 00 29 01 08 00 09 00 |).......|..).....|
|00004db0| 01 1a 05 00 29 01 0a 00 | 0b 00 01 15 07 00 01 00 |....)...|........|
|00004dc0| 19 01 0c 00 ff 9b ff ff | ff ff 0e 01 02 01 1a 00 |........|........|
|00004dd0| 00 29 01 00 00 01 00 01 | 1a 01 00 29 01 02 00 03 |.)......|...)....|
|00004de0| 00 01 1a 02 00 29 01 04 | 00 05 00 01 1a 03 00 29 |.....)..|.......)|
|00004df0| 01 06 00 07 00 01 1a 04 | 00 29 01 08 00 09 00 01 |........|.)......|
|00004e00| 1a 05 00 29 01 0a 00 0b | 00 01 15 07 00 00 00 19 |...)....|........|
|00004e10| 01 0c 00 ff ff 4c 09 0e | 53 51 4c 24 4d 41 49 4c |.....L..|SQL$MAIL|
|00004e20| 5f 4c 41 42 45 4c 0a 06 | 53 59 53 44 42 41 00 1c |_LABEL..|SYSDBA..|
|00004e30| 01 07 43 55 53 54 5f 4e | 4f 02 04 00 00 00 00 03 |..CUST_N|O.......|
|00004e40| 04 00 00 00 00 04 06 52 | 44 42 24 34 39 00 1c 01 |.......R|DB$49...|
|00004e50| 05 4c 49 4e 45 31 02 04 | 00 00 00 00 03 04 01 00 |.LINE1..|........|
|00004e60| 00 00 04 06 52 44 42 24 | 35 30 00 1c 01 05 4c 49 |....RDB$|50....LI|
|00004e70| 4e 45 32 02 04 01 00 00 | 00 03 04 01 00 00 00 04 |NE2.....|........|
|00004e80| 06 52 44 42 24 35 31 00 | 1c 01 05 4c 49 4e 45 33 |.RDB$51.|...LINE3|
|00004e90| 02 04 02 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|00004ea0| 42 24 35 32 00 1c 01 05 | 4c 49 4e 45 34 02 04 03 |B$52....|LINE4...|
|00004eb0| 00 00 00 03 04 01 00 00 | 00 04 06 52 44 42 24 35 |........|...RDB$5|
|00004ec0| 33 00 1c 01 05 4c 49 4e | 45 35 02 04 04 00 00 00 |3....LIN|E5......|
|00004ed0| 03 04 01 00 00 00 04 06 | 52 44 42 24 35 34 00 1c |........|RDB$54..|
|00004ee0| 01 05 4c 49 4e 45 36 02 | 04 05 00 00 00 03 04 01 |..LINE6.|........|
|00004ef0| 00 00 00 04 06 52 44 42 | 24 35 35 00 1d 1b 01 0a |.....RDB|$55.....|
|00004f00| 53 48 49 50 5f 4f 52 44 | 45 52 02 04 01 00 00 00 |SHIP_ORD|ER......|
|00004f10| 03 04 00 00 00 00 07 04 | 49 04 00 00 0a 20 44 45 |........|I.... DE|
|00004f20| 43 4c 41 52 45 20 56 41 | 52 49 41 42 4c 45 20 6f |CLARE VA|RIABLE o|
|00004f30| 72 64 5f 73 74 61 74 20 | 43 48 41 52 28 37 29 3b |rd_stat |CHAR(7);|
|00004f40| 0a 20 44 45 43 4c 41 52 | 45 20 56 41 52 49 41 42 |. DECLAR|E VARIAB|
|00004f50| 4c 45 20 68 6f 6c 64 5f | 73 74 61 74 20 43 48 41 |LE hold_|stat CHA|
|00004f60| 52 28 31 29 3b 0a 20 44 | 45 43 4c 41 52 45 20 56 |R(1);. D|ECLARE V|
|00004f70| 41 52 49 41 42 4c 45 20 | 63 75 73 74 5f 6e 6f 20 |ARIABLE |cust_no |
|00004f80| 49 4e 54 45 47 45 52 3b | 0a 20 44 45 43 4c 41 52 |INTEGER;|. DECLAR|
|00004f90| 45 20 56 41 52 49 41 42 | 4c 45 20 61 6e 79 5f 70 |E VARIAB|LE any_p|
|00004fa0| 6f 20 43 48 41 52 28 38 | 29 3b 0a 42 45 47 49 4e |o CHAR(8|);.BEGIN|
|00004fb0| 0a 20 53 45 4c 45 43 54 | 20 73 2e 6f 72 64 65 72 |. SELECT| s.order|
|00004fc0| 5f 73 74 61 74 75 73 2c | 20 63 2e 6f 6e 5f 68 6f |_status,| c.on_ho|
|00004fd0| 6c 64 2c 20 63 2e 63 75 | 73 74 5f 6e 6f 0a 20 46 |ld, c.cu|st_no. F|
|00004fe0| 52 4f 4d 20 73 61 6c 65 | 73 20 73 2c 20 63 75 73 |ROM sale|s s, cus|
|00004ff0| 74 6f 6d 65 72 20 63 0a | 20 57 48 45 52 45 20 70 |tomer c.| WHERE p|
|00005000| 6f 5f 6e 75 6d 62 65 72 | 20 3d 20 3a 70 6f 5f 6e |o_number| = :po_n|
|00005010| 75 6d 0a 20 41 4e 44 20 | 73 2e 63 75 73 74 5f 6e |um. AND |s.cust_n|
|00005020| 6f 20 3d 20 63 2e 63 75 | 73 74 5f 6e 6f 0a 20 49 |o = c.cu|st_no. I|
|00005030| 4e 54 4f 20 3a 6f 72 64 | 5f 73 74 61 74 2c 20 3a |NTO :ord|_stat, :|
|00005040| 68 6f 6c 64 5f 73 74 61 | 74 2c 20 3a 63 75 73 74 |hold_sta|t, :cust|
|00005050| 5f 6e 6f 3b 0a 0a 20 2f | 2a 20 54 68 69 73 20 70 |_no;.. /|* This p|
|00005060| 75 72 63 68 61 73 65 20 | 6f 72 64 65 72 20 68 61 |urchase |order ha|
|00005070| 73 20 62 65 65 6e 20 61 | 6c 72 65 61 64 79 20 73 |s been a|lready s|
|00005080| 68 69 70 70 65 64 2e 20 | 2a 2f 0a 20 49 46 20 28 |hipped. |*/. IF (|
|00005090| 6f 72 64 5f 73 74 61 74 | 20 3d 20 22 73 68 69 70 |ord_stat| = "ship|
|000050a0| 70 65 64 22 29 20 54 48 | 45 4e 0a 20 42 45 47 49 |ped") TH|EN. BEGI|
|000050b0| 4e 0a 20 20 45 58 43 45 | 50 54 49 4f 4e 20 6f 72 |N.  EXCE|PTION or|
|000050c0| 64 65 72 5f 61 6c 72 65 | 61 64 79 5f 73 68 69 70 |der_alre|ady_ship|
|000050d0| 70 65 64 3b 0a 20 20 53 | 55 53 50 45 4e 44 3b 0a |ped;.  S|USPEND;.|
|000050e0| 20 45 4e 44 0a 0a 20 2f | 2a 20 43 75 73 74 6f 6d | END.. /|* Custom|
|000050f0| 65 72 20 69 73 20 6f 6e | 20 68 6f 6c 64 2e 20 2a |er is on| hold. *|
|00005100| 2f 0a 20 45 4c 53 45 20 | 49 46 20 28 68 6f 6c 64 |/. ELSE |IF (hold|
|00005110| 5f 73 74 61 74 20 3d 20 | 22 2a 22 29 00 20 54 48 |_stat = |"*"). TH|
|00005120| 45 4e 0a 20 42 45 47 49 | 4e 0a 20 20 45 58 43 45 |EN. BEGI|N.  EXCE|
|00005130| 50 54 49 4f 4e 20 63 75 | 73 74 6f 6d 65 72 5f 6f |PTION cu|stomer_o|
|00005140| 6e 5f 68 6f 6c 64 3b 0a | 20 20 53 55 53 50 45 4e |n_hold;.|  SUSPEN|
|00005150| 44 3b 0a 20 45 4e 44 0a | 0a 20 2f 2a 0a 20 20 2a |D;. END.|. /*.  *|
|00005160| 20 49 66 20 74 68 65 72 | 65 20 69 73 20 61 6e 20 | If ther|e is an |
|00005170| 75 6e 70 61 69 64 20 62 | 61 6c 61 6e 63 65 20 6f |unpaid b|alance o|
|00005180| 6e 20 6f 72 64 65 72 73 | 20 73 68 69 70 70 65 64 |n orders| shipped|
|00005190| 20 6f 76 65 72 20 32 20 | 6d 6f 6e 74 68 73 20 61 | over 2 |months a|
|000051a0| 67 6f 2c 0a 20 20 2a 20 | 70 75 74 20 74 68 65 20 |go,.  * |put the |
|000051b0| 63 75 73 74 6f 6d 65 72 | 20 6f 6e 20 68 6f 6c 64 |customer| on hold|
|000051c0| 2e 0a 20 20 2a 2f 0a 20 | 46 4f 52 20 53 45 4c 45 |..  */. |FOR SELE|
|000051d0| 43 54 20 70 6f 5f 6e 75 | 6d 62 65 72 0a 20 20 46 |CT po_nu|mber.  F|
|000051e0| 52 4f 4d 20 73 61 6c 65 | 73 0a 20 20 57 48 45 52 |ROM sale|s.  WHER|
|000051f0| 45 20 63 75 73 74 5f 6e | 6f 20 3d 20 3a 63 75 73 |E cust_n|o = :cus|
|00005200| 74 5f 6e 6f 0a 20 20 41 | 4e 44 20 6f 72 64 65 72 |t_no.  A|ND order|
|00005210| 5f 73 74 61 74 75 73 20 | 3d 20 22 73 68 69 70 70 |_status |= "shipp|
|00005220| 65 64 22 0a 20 20 41 4e | 44 20 70 61 69 64 20 3d |ed".  AN|D paid =|
|00005230| 20 22 6e 22 0a 20 20 41 | 4e 44 20 73 68 69 70 5f | "n".  A|ND ship_|
|00005240| 64 61 74 65 20 3c 20 27 | 4e 4f 57 27 20 2d 20 36 |date < '|NOW' - 6|
|00005250| 30 0a 20 20 49 4e 54 4f | 20 3a 61 6e 79 5f 70 6f |0.  INTO| :any_po|
|00005260| 0a 20 44 4f 0a 20 42 45 | 47 49 4e 0a 20 20 45 58 |. DO. BE|GIN.  EX|
|00005270| 43 45 50 54 49 4f 4e 20 | 63 75 73 74 6f 6d 65 72 |CEPTION |customer|
|00005280| 5f 63 68 65 63 6b 3b 0a | 0a 20 20 55 50 44 41 54 |_check;.|.  UPDAT|
|00005290| 45 20 63 75 73 74 6f 6d | 65 72 0a 20 20 53 45 54 |E custom|er.  SET|
|000052a0| 20 6f 6e 5f 68 6f 6c 64 | 20 3d 20 22 2a 22 0a 20 | on_hold| = "*". |
|000052b0| 20 57 48 45 52 45 20 63 | 75 73 74 5f 6e 6f 20 3d | WHERE c|ust_no =|
|000052c0| 20 3a 63 75 73 74 5f 6e | 6f 3b 0a 0a 20 20 53 55 | :cust_n|o;..  SU|
|000052d0| 53 50 45 4e 44 3b 0a 20 | 45 4e 44 0a 0a 20 2f 2a |SPEND;. |END.. /*|
|000052e0| 0a 20 20 2a 20 53 68 69 | 70 20 74 68 65 20 6f 72 |.  * Shi|p the or|
|000052f0| 64 65 72 2e 0a 20 20 2a | 2f 0a 20 55 50 44 41 54 |der..  *|/. UPDAT|
|00005300| 45 20 73 61 6c 65 73 0a | 20 53 45 54 20 6f 72 64 |E sales.| SET ord|
|00005310| 65 72 5f 73 74 61 74 75 | 73 20 3d 20 22 00 73 68 |er_statu|s = ".sh|
|00005320| 69 70 70 65 64 22 2c 20 | 73 68 69 70 5f 64 61 74 |ipped", |ship_dat|
|00005330| 65 20 3d 20 27 4e 4f 57 | 27 0a 20 57 48 45 52 45 |e = 'NOW|'. WHERE|
|00005340| 20 70 6f 5f 6e 75 6d 62 | 65 72 20 3d 20 3a 70 6f | po_numb|er = :po|
|00005350| 5f 6e 75 6d 3b 0a 0a 20 | 53 55 53 50 45 4e 44 3b |_num;.. |SUSPEND;|
|00005360| 0a 45 4e 44 00 08 04 88 | 02 00 00 04 02 04 00 02 |.END....|........|
|00005370| 00 0f 00 00 08 00 07 00 | 04 01 01 00 07 00 0c 00 |........|........|
|00005380| 02 03 00 00 0f 00 00 07 | 00 01 2d 1a 00 00 03 01 |........|..-.....|
|00005390| 00 0f 00 00 01 00 01 2d | 1a 01 00 03 02 00 08 00 |.......-|........|
|000053a0| 01 2d 1a 02 00 03 03 00 | 0f 00 00 08 00 01 2d 1a |.-......|......-.|
|000053b0| 03 00 9b 11 00 02 02 07 | 7f 43 02 92 05 53 41 4c |........|.C...SAL|
|000053c0| 45 53 01 53 00 92 08 43 | 55 53 54 4f 4d 45 52 01 |ES.S...C|USTOMER.|
|000053d0| 43 01 47 3a 2f 17 00 09 | 50 4f 5f 4e 55 4d 42 45 |C.G:/...|PO_NUMBE|
|000053e0| 52 29 00 00 00 01 00 2f | 17 00 07 43 55 53 54 5f |R)...../|...CUST_|
|000053f0| 4e 4f 17 01 07 43 55 53 | 54 5f 4e 4f ff 02 01 17 |NO...CUS|T_NO....|
|00005400| 00 0c 4f 52 44 45 52 5f | 53 54 41 54 55 53 1a 00 |..ORDER_|STATUS..|
|00005410| 00 01 17 01 07 4f 4e 5f | 48 4f 4c 44 1a 01 00 01 |.....ON_|HOLD....|
|00005420| 17 01 07 43 55 53 54 5f | 4e 4f 1a 02 00 ff 08 2f |...CUST_|NO...../|
|00005430| 1a 00 00 15 0f 7f 00 07 | 00 73 68 69 70 70 65 64 |........|.shipped|
|00005440| 02 02 80 02 15 4f 52 44 | 45 52 5f 41 4c 52 45 41 |.....ORD|ER_ALREA|
|00005450| 44 59 5f 53 48 49 50 50 | 45 44 02 0e 01 02 01 15 |DY_SHIPP|ED......|
|00005460| 07 00 01 00 19 01 00 00 | ff 9b ff ff ff 08 2f 1a |........|....../.|
|00005470| 01 00 15 0f 7f 00 01 00 | 2a 02 02 80 02 10 43 55 |........|*.....CU|
|00005480| 53 54 4f 4d 45 52 5f 4f | 4e 5f 48 4f 4c 44 02 0e |STOMER_O|N_HOLD..|
|00005490| 01 02 01 15 07 00 01 00 | 19 01 00 00 ff 9b ff ff |........|........|
|000054a0| ff ff 07 43 01 4a 05 53 | 41 4c 45 53 02 47 3a 3a |...C.J.S|ALES.G::|
|000054b0| 3a 2f 17 02 07 43 55 53 | 54 5f 4e 4f 1a 02 00 2f |:/...CUS|T_NO.../|
|000054c0| 17 02 0c 4f 52 44 45 52 | 5f 53 54 41 54 55 53 15 |...ORDER|_STATUS.|
|000054d0| 0f 7f 00 07 00 73 68 69 | 70 70 65 64 2f 17 02 04 |.....shi|pped/...|
|000054e0| 50 41 49 44 15 0f 7f 00 | 01 00 6e 33 17 02 09 53 |PAID....|..n3...S|
|000054f0| 48 49 50 5f 44 41 54 45 | 23 15 0f 7f 00 03 00 4e |HIP_DATE|#......N|
|00005500| 4f 57 15 08 00 3c 00 00 | 00 ff 02 01 17 02 09 50 |OW...<..|.......P|
|00005510| 4f 5f 4e 55 4d 42 45 52 | 1a 03 00 02 02 80 02 0e |O_NUMBER|........|
|00005520| 43 55 53 54 4f 4d 45 52 | 5f 43 48 45 43 4b 07 43 |CUSTOMER|_CHECK.C|
|00005530| 01 4a 08 43 55 53 54 4f | 4d 45 52 03 47 2f 17 03 |.J.CUSTO|MER.G/..|
|00005540| 07 43 55 53 54 5f 4e 4f | 1a 02 00 ff 0a 03 03 02 |.CUST_NO|........|
|00005550| 01 15 0f 7f 00 01 00 2a | 17 03 07 4f 4e 5f 48 4f |.......*|...ON_HO|
|00005560| 4c 44 ff 02 0e 01 02 01 | 15 07 00 01 00 19 01 00 |LD......|........|
|00005570| 00 ff 9b ff ff ff ff 07 | 43 01 4a 05 53 41 4c 45 |........|C.J.SALE|
|00005580| 53 04 47 2f 17 04 09 50 | 4f 5f 4e 55 4d 42 45 52 |S.G/...P|O_NUMBER|
|00005590| 29 00 00 00 01 00 ff 0a | 04 04 02 01 15 0f 7f 00 |).......|........|
|000055a0| 07 00 73 68 69 70 70 65 | 64 17 04 0c 4f 52 44 45 |..shippe|d...ORDE|
|000055b0| 52 5f 53 54 41 54 55 53 | 01 15 0f 7f 00 03 00 4e |R_STATUS|.......N|
|000055c0| 4f 57 17 04 09 53 48 49 | 50 5f 44 41 54 45 ff 02 |OW...SHI|P_DATE..|
|000055d0| 0e 01 02 01 15 07 00 01 | 00 19 01 00 00 ff 9b ff |........|........|
|000055e0| ff ff ff 0e 01 02 01 15 | 07 00 00 00 19 01 00 00 |........|........|
|000055f0| ff ff 4c 09 0e 53 51 4c | 24 53 48 49 50 5f 4f 52 |..L..SQL|$SHIP_OR|
|00005600| 44 45 52 0a 06 53 59 53 | 44 42 41 00 1c 01 06 50 |DER..SYS|DBA....P|
|00005610| 4f 5f 4e 55 4d 02 04 00 | 00 00 00 03 04 00 00 00 |O_NUM...|........|
|00005620| 00 04 06 52 44 42 24 35 | 36 00 1d 1b 01 0a 53 48 |...RDB$5|6.....SH|
|00005630| 4f 57 5f 4c 41 4e 47 53 | 02 04 03 00 00 00 03 04 |OW_LANGS|........|
|00005640| 01 00 00 00 07 04 8b 01 | 00 00 0a 44 45 43 4c 41 |........|...DECLA|
|00005650| 52 45 20 56 41 52 49 41 | 42 4c 45 20 69 20 49 4e |RE VARIA|BLE i IN|
|00005660| 54 45 47 45 52 3b 0a 42 | 45 47 49 4e 0a 20 20 69 |TEGER;.B|EGIN.  i|
|00005670| 20 3d 20 31 3b 0a 20 20 | 57 48 49 4c 45 20 28 69 | = 1;.  |WHILE (i|
|00005680| 20 3c 3d 20 35 29 20 44 | 4f 0a 20 20 42 45 47 49 | <= 5) D|O.  BEGI|
|00005690| 4e 0a 20 20 20 20 53 45 | 4c 45 43 54 20 6c 61 6e |N.    SE|LECT lan|
|000056a0| 67 75 61 67 65 5f 72 65 | 71 5b 3a 69 5d 20 46 52 |guage_re|q[:i] FR|
|000056b0| 4f 4d 20 6a 6f 42 0a 20 | 20 20 20 57 48 45 52 45 |OM joB. |   WHERE|
|000056c0| 20 28 28 6a 6f 62 5f 63 | 6f 64 65 20 3d 20 3a 63 | ((job_c|ode = :c|
|000056d0| 6f 64 65 29 20 41 4e 44 | 20 28 6a 6f 62 5f 67 72 |ode) AND| (job_gr|
|000056e0| 61 64 65 20 3d 20 3a 67 | 72 61 64 65 29 20 41 4e |ade = :g|rade) AN|
|000056f0| 44 20 28 6a 6f 62 5f 63 | 6f 75 6e 74 72 79 20 3d |D (job_c|ountry =|
|00005700| 20 3a 63 74 79 29 0a 20 | 20 20 20 20 20 20 20 20 | :cty). |        |
|00005710| 20 20 41 4e 44 20 28 6c | 61 6e 67 75 61 67 65 5f |  AND (l|anguage_|
|00005720| 72 65 71 20 49 53 20 4e | 4f 54 20 4e 55 4c 4c 29 |req IS N|OT NULL)|
|00005730| 29 0a 20 20 20 20 49 4e | 54 4f 20 3a 6c 61 6e 67 |).    IN|TO :lang|
|00005740| 75 61 67 65 73 3b 0a 20 | 20 20 20 49 46 20 28 6c |uages;. |   IF (l|
|00005750| 61 6e 67 75 61 67 65 73 | 20 3d 20 22 20 22 29 20 |anguages| = " ") |
|00005760| 54 48 45 4e 20 20 2f 2a | 20 50 72 69 6e 74 73 20 |THEN  /*| Prints |
|00005770| 22 4e 55 4c 4c 22 20 69 | 6e 73 74 65 61 64 20 6f |"NULL" i|nstead o|
|00005780| 66 20 62 6c 61 6e 6b 73 | 20 2a 2f 0a 20 20 20 20 |f blanks| */.    |
|00005790| 20 20 20 6c 61 6e 67 75 | 61 67 65 73 20 3d 20 22 |   langu|ages = "|
|000057a0| 4e 55 4c 4c 22 3b 20 20 | 20 20 20 20 20 20 20 0a |NULL";  |       .|
|000057b0| 20 20 20 20 69 20 3d 20 | 69 20 2b 31 3b 0a 20 20 |    i = |i +1;.  |
|000057c0| 20 20 53 55 53 50 45 4e | 44 3b 0a 20 20 45 4e 44 |  SUSPEN|D;.  END|
|000057d0| 0a 45 4e 44 00 08 04 3c | 01 00 00 04 02 04 00 06 |.END...<|........|
|000057e0| 00 26 00 00 05 00 07 00 | 07 00 07 00 26 00 00 0f |.&......|....&...|
|000057f0| 00 07 00 04 01 03 00 26 | 00 00 0f 00 07 00 07 00 |.......&|........|
|00005800| 0c 00 02 03 00 00 26 00 | 00 0f 00 01 2d 1a 00 00 |......&.|....-...|
|00005810| 03 01 00 08 00 01 2d 1a | 01 00 9b 11 00 02 02 01 |......-.|........|
|00005820| 15 08 00 01 00 00 00 1a | 01 00 11 01 09 02 08 34 |........|.......4|
|00005830| 1a 01 00 15 08 00 05 00 | 00 00 02 02 07 7f 43 01 |........|......C.|
|00005840| 4a 03 4a 4f 42 00 47 3a | 3a 3a 2f 17 00 08 4a 4f |J.JOB.G:|::/...JO|
|00005850| 42 5f 43 4f 44 45 29 00 | 00 00 01 00 2f 17 00 09 |B_CODE).|..../...|
|00005860| 4a 4f 42 5f 47 52 41 44 | 45 29 00 02 00 03 00 2f |JOB_GRAD|E)...../|
|00005870| 17 00 0b 4a 4f 42 5f 43 | 4f 55 4e 54 52 59 29 00 |...JOB_C|OUNTRY).|
|00005880| 04 00 05 00 3b 3d 17 00 | 0c 4c 41 4e 47 55 41 47 |....;=..|.LANGUAG|
|00005890| 45 5f 52 45 51 ff 02 01 | 6b 17 00 0c 4c 41 4e 47 |E_REQ...|k...LANG|
|000058a0| 55 41 47 45 5f 52 45 51 | 01 1a 01 00 1a 00 00 ff |UAGE_REQ|........|
|000058b0| 08 2f 1a 00 00 15 0f 7f | 00 01 00 20 01 15 0f 7f |./......|... ....|
|000058c0| 00 04 00 4e 55 4c 4c 1a | 00 00 ff 01 22 1a 01 00 |...NULL.|...."...|
|000058d0| 15 08 00 01 00 00 00 1a | 01 00 02 0e 01 02 01 1a |........|........|
|000058e0| 00 00 29 01 00 00 01 00 | 01 15 07 00 01 00 19 01 |..).....|........|
|000058f0| 02 00 ff 9b ff ff ff 12 | 01 ff ff ff ff 0e 01 02 |........|........|
|00005900| 01 1a 00 00 29 01 00 00 | 01 00 01 15 07 00 00 00 |....)...|........|
|00005910| 19 01 02 00 ff ff 4c 09 | 0e 53 51 4c 24 53 48 4f |......L.|.SQL$SHO|
|00005920| 57 5f 4c 41 4e 47 53 0a | 06 53 59 53 44 42 41 00 |W_LANGS.|.SYSDBA.|
|00005930| 1c 01 04 43 4f 44 45 02 | 04 00 00 00 00 03 04 00 |...CODE.|........|
|00005940| 00 00 00 04 06 52 44 42 | 24 35 37 00 1c 01 05 47 |.....RDB|$57....G|
|00005950| 52 41 44 45 02 04 01 00 | 00 00 03 04 00 00 00 00 |RADE....|........|
|00005960| 04 06 52 44 42 24 35 38 | 00 1c 01 03 43 54 59 02 |..RDB$58|....CTY.|
|00005970| 04 02 00 00 00 03 04 00 | 00 00 00 04 06 52 44 42 |........|.....RDB|
|00005980| 24 35 39 00 1c 01 09 4c | 41 4e 47 55 41 47 45 53 |$59....L|ANGUAGES|
|00005990| 02 04 00 00 00 00 03 04 | 01 00 00 00 04 06 52 44 |........|......RD|
|000059a0| 42 24 36 30 00 1d 1b 01 | 09 41 4c 4c 5f 4c 41 4e |B$60....|.ALL_LAN|
|000059b0| 47 53 02 04 00 00 00 00 | 03 04 04 00 00 00 07 04 |GS......|........|
|000059c0| 8b 01 00 00 0a 20 20 20 | 20 42 45 47 49 4e 0a 20 |.....   | BEGIN. |
|000059d0| 46 4f 52 20 53 45 4c 45 | 43 54 20 6a 6f 62 5f 63 |FOR SELE|CT job_c|
|000059e0| 6f 64 65 2c 20 6a 6f 62 | 5f 67 72 61 64 65 2c 20 |ode, job|_grade, |
|000059f0| 6a 6f 62 5f 63 6f 75 6e | 74 72 79 20 46 52 4f 4d |job_coun|try FROM|
|00005a00| 20 6a 6f 62 20 0a 20 20 | 49 4e 54 4f 20 3a 63 6f | job .  |INTO :co|
|00005a10| 64 65 2c 20 3a 67 72 61 | 64 65 2c 20 3a 63 6f 75 |de, :gra|de, :cou|
|00005a20| 6e 74 72 79 0a 0a 20 44 | 4f 0a 20 42 45 47 49 4e |ntry.. D|O. BEGIN|
|00005a30| 0a 20 20 20 20 20 46 4f | 52 20 53 45 4c 45 43 54 |.     FO|R SELECT|
|00005a40| 20 6c 61 6e 67 75 61 67 | 65 73 20 46 52 4f 4d 20 | languag|es FROM |
|00005a50| 73 68 6f 77 5f 6c 61 6e | 67 73 20 0a 20 20 20 20 |show_lan|gs .    |
|00005a60| 20 20 20 28 3a 63 6f 64 | 65 2c 20 3a 67 72 61 64 |   (:cod|e, :grad|
|00005a70| 65 2c 20 3a 63 6f 75 6e | 74 72 79 29 20 49 4e 54 |e, :coun|try) INT|
|00005a80| 4f 20 3a 6c 61 6e 67 20 | 44 4f 0a 20 20 20 20 20 |O :lang |DO.     |
|00005a90| 20 20 20 20 53 55 53 50 | 45 4e 44 3b 0a 20 20 20 |    SUSP|END;.   |
|00005aa0| 20 20 2f 2a 20 50 75 74 | 20 6e 69 63 65 20 73 65 |  /* Put| nice se|
|00005ab0| 70 61 72 61 74 6f 72 73 | 20 62 65 74 77 65 65 6e |parators| between|
|00005ac0| 20 72 6f 77 73 20 2a 2f | 0a 20 20 20 20 20 63 6f | rows */|.     co|
|00005ad0| 64 65 20 3d 20 22 3d 3d | 3d 3d 3d 22 3b 0a 20 20 |de = "==|===";.  |
|00005ae0| 20 20 20 67 72 61 64 65 | 20 3d 20 22 3d 3d 3d 3d |   grade| = "====|
|00005af0| 3d 22 3b 0a 20 20 20 20 | 20 63 6f 75 6e 74 72 79 |=";.    | country|
|00005b00| 20 3d 20 22 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d | = "====|========|
|00005b10| 3d 3d 3d 22 3b 0a 20 20 | 20 20 20 6c 61 6e 67 20 |===";.  |   lang |
|00005b20| 3d 20 22 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |= "=====|========|
|00005b30| 3d 22 3b 0a 20 20 20 20 | 20 53 55 53 50 45 4e 44 |=";.    | SUSPEND|
|00005b40| 3b 0a 20 45 4e 44 0a 20 | 20 20 20 45 4e 44 00 08 |;. END. |   END..|
|00005b50| 04 c9 01 00 00 04 02 04 | 01 09 00 26 00 00 05 00 |........|...&....|
|00005b60| 07 00 26 00 00 05 00 07 | 00 26 00 00 0f 00 07 00 |..&.....|.&......|
|00005b70| 26 00 00 0f 00 07 00 07 | 00 02 03 00 00 26 00 00 |&.......|.....&..|
|00005b80| 05 00 01 2d 1a 00 00 03 | 01 00 26 00 00 05 00 01 |...-....|..&.....|
|00005b90| 2d 1a 01 00 03 02 00 26 | 00 00 0f 00 01 2d 1a 02 |-......&|.....-..|
|00005ba0| 00 03 03 00 26 00 00 0f | 00 01 2d 1a 03 00 9b 11 |....&...|..-.....|
|00005bb0| 00 02 02 07 43 01 4a 03 | 4a 4f 42 00 ff 02 01 17 |....C.J.|JOB.....|
|00005bc0| 00 08 4a 4f 42 5f 43 4f | 44 45 1a 00 00 01 17 00 |..JOB_CO|DE......|
|00005bd0| 09 4a 4f 42 5f 47 52 41 | 44 45 1a 01 00 01 17 00 |.JOB_GRA|DE......|
|00005be0| 0b 4a 4f 42 5f 43 4f 55 | 4e 54 52 59 1a 02 00 02 |.JOB_COU|NTRY....|
|00005bf0| 02 07 43 01 7c 0a 53 48 | 4f 57 5f 4c 41 4e 47 53 |..C.|.SH|OW_LANGS|
|00005c00| 01 03 00 1a 00 00 1a 01 | 00 1a 02 00 ff 02 01 17 |........|........|
|00005c10| 01 09 4c 41 4e 47 55 41 | 47 45 53 1a 03 00 02 0e |..LANGUA|GES.....|
|00005c20| 01 02 01 1a 00 00 29 01 | 00 00 01 00 01 1a 01 00 |......).|........|
|00005c30| 29 01 02 00 03 00 01 1a | 02 00 29 01 04 00 05 00 |).......|..).....|
|00005c40| 01 1a 03 00 29 01 06 00 | 07 00 01 15 07 00 01 00 |....)...|........|
|00005c50| 19 01 08 00 ff 9b ff ff | 01 15 0f 7f 00 05 00 3d |........|.......=|
|00005c60| 3d 3d 3d 3d 1a 00 00 01 | 15 0f 7f 00 05 00 3d 3d |====....|......==|
|00005c70| 3d 3d 3d 1a 01 00 01 15 | 0f 7f 00 0f 00 3d 3d 3d |===.....|.....===|
|00005c80| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 1a 02 00 01 |========|====....|
|00005c90| 15 0f 7f 00 0e 00 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |......==|========|
|00005ca0| 3d 3d 3d 3d 1a 03 00 02 | 0e 01 02 01 1a 00 00 29 |====....|.......)|
|00005cb0| 01 00 00 01 00 01 1a 01 | 00 29 01 02 00 03 00 01 |........|.)......|
|00005cc0| 1a 02 00 29 01 04 00 05 | 00 01 1a 03 00 29 01 06 |...)....|.....)..|
|00005cd0| 00 07 00 01 15 07 00 01 | 00 19 01 08 00 ff 9b ff |........|........|
|00005ce0| ff ff ff ff ff ff 0e 01 | 02 01 1a 00 00 29 01 00 |........|.....)..|
|00005cf0| 00 01 00 01 1a 01 00 29 | 01 02 00 03 00 01 1a 02 |.......)|........|
|00005d00| 00 29 01 04 00 05 00 01 | 1a 03 00 29 01 06 00 07 |.)......|...)....|
|00005d10| 00 01 15 07 00 00 00 19 | 01 08 00 ff ff 4c 09 0d |........|.....L..|
|00005d20| 53 51 4c 24 41 4c 4c 5f | 4c 41 4e 47 53 0a 06 53 |SQL$ALL_|LANGS..S|
|00005d30| 59 53 44 42 41 00 1c 01 | 04 43 4f 44 45 02 04 00 |YSDBA...|.CODE...|
|00005d40| 00 00 00 03 04 01 00 00 | 00 04 06 52 44 42 24 36 |........|...RDB$6|
|00005d50| 31 00 1c 01 05 47 52 41 | 44 45 02 04 01 00 00 00 |1....GRA|DE......|
|00005d60| 03 04 01 00 00 00 04 06 | 52 44 42 24 36 32 00 1c |........|RDB$62..|
|00005d70| 01 07 43 4f 55 4e 54 52 | 59 02 04 02 00 00 00 03 |..COUNTR|Y.......|
|00005d80| 04 01 00 00 00 04 06 52 | 44 42 24 36 33 00 1c 01 |.......R|DB$63...|
|00005d90| 04 4c 41 4e 47 02 04 03 | 00 00 00 03 04 01 00 00 |.LANG...|........|
|00005da0| 00 04 06 52 44 42 24 36 | 34 00 1d 1e 01 0e 55 4e |...RDB$6|4.....UN|
|00005db0| 4b 4e 4f 57 4e 5f 45 4d | 50 5f 49 44 02 26 49 6e |KNOWN_EM|P_ID.&In|
|00005dc0| 76 61 6c 69 64 20 65 6d | 70 6c 6f 79 65 65 20 6e |valid em|ployee n|
|00005dd0| 75 6d 62 65 72 20 6f 72 | 20 70 72 6f 6a 65 63 74 |umber or| project|
|00005de0| 20 69 64 2e 00 1e 01 0e | 52 45 41 53 53 49 47 4e | id.....|REASSIGN|
|00005df0| 5f 53 41 4c 45 53 02 39 | 52 65 61 73 73 69 67 6e |_SALES.9|Reassign|
|00005e00| 20 74 68 65 20 73 61 6c | 65 73 20 72 65 63 6f 72 | the sal|es recor|
|00005e10| 64 73 20 62 65 66 6f 72 | 65 20 64 65 6c 65 74 69 |ds befor|e deleti|
|00005e20| 6e 67 20 74 68 69 73 20 | 65 6d 70 6c 6f 79 65 65 |ng this |employee|
|00005e30| 2e 00 1e 01 15 4f 52 44 | 45 52 5f 41 4c 52 45 41 |.....ORD|ER_ALREA|
|00005e40| 44 59 5f 53 48 49 50 50 | 45 44 02 1a 4f 72 64 65 |DY_SHIPP|ED..Orde|
|00005e50| 72 20 73 74 61 74 75 73 | 20 69 73 20 27 73 68 69 |r status| is 'shi|
|00005e60| 70 70 65 64 2e 27 00 1e | 01 10 43 55 53 54 4f 4d |pped.'..|..CUSTOM|
|00005e70| 45 52 5f 4f 4e 5f 48 4f | 4c 44 02 19 54 68 69 73 |ER_ON_HO|LD..This|
|00005e80| 20 63 75 73 74 6f 6d 65 | 72 20 69 73 20 6f 6e 20 | custome|r is on |
|00005e90| 68 6f 6c 64 2e 00 1e 01 | 0e 43 55 53 54 4f 4d 45 |hold....|.CUSTOME|
|00005ea0| 52 5f 43 48 45 43 4b 02 | 1e 4f 76 65 72 64 75 65 |R_CHECK.|.Overdue|
|00005eb0| 20 62 61 6c 61 6e 63 65 | 20 2d 2d 20 63 61 6e 27 | balance| -- can'|
|00005ec0| 74 20 73 68 69 70 2e 00 | 08 01 0e 53 41 4c 41 52 |t ship..|...SALAR|
|00005ed0| 59 5f 48 49 53 54 4f 52 | 59 00 05 01 0d 52 44 42 |Y_HISTOR|Y....RDB|
|00005ee0| 24 50 52 49 4d 41 52 59 | 32 30 02 04 03 00 00 00 |$PRIMARY|20......|
|00005ef0| 03 04 00 00 00 00 04 04 | 01 00 00 00 05 06 45 4d |........|......EM|
|00005f00| 50 5f 4e 4f 05 0b 43 48 | 41 4e 47 45 5f 44 41 54 |P_NO..CH|ANGE_DAT|
|00005f10| 45 05 0a 55 50 44 41 54 | 45 52 5f 49 44 07 04 00 |E..UPDAT|ER_ID...|
|00005f20| 00 00 00 00 05 01 0d 52 | 44 42 24 46 4f 52 45 49 |.......R|DB$FOREI|
|00005f30| 47 4e 32 31 02 04 01 00 | 00 00 03 04 00 00 00 00 |GN21....|........|
|00005f40| 04 04 00 00 00 00 05 06 | 45 4d 50 5f 4e 4f 07 04 |........|EMP_NO..|
|00005f50| 00 00 00 00 08 0c 52 44 | 42 24 50 52 49 4d 41 52 |......RD|B$PRIMAR|
|00005f60| 59 37 00 05 01 08 55 50 | 44 41 54 45 52 58 02 04 |Y7....UP|DATERX..|
|00005f70| 01 00 00 00 03 04 00 00 | 00 00 04 04 00 00 00 00 |........|........|
|00005f80| 05 0a 55 50 44 41 54 45 | 52 5f 49 44 07 04 00 00 |..UPDATE|R_ID....|
|00005f90| 00 00 00 05 01 07 43 48 | 41 4e 47 45 58 02 04 01 |......CH|ANGEX...|
|00005fa0| 00 00 00 03 04 00 00 00 | 00 04 04 00 00 00 00 05 |........|........|
|00005fb0| 0b 43 48 41 4e 47 45 5f | 44 41 54 45 07 04 01 00 |.CHANGE_|DATE....|
|00005fc0| 00 00 00 06 01 04 3a 00 | 00 00 11 04 3c 00 00 00 |......:.|....<...|
|00005fd0| 02 02 40 24 fa 00 03 40 | d3 88 f9 00 02 bf 4b f9 |..@$...@|......K.|
|00005fe0| 00 09 06 61 64 6d 69 6e | 32 4c c4 fd 00 01 1c ec |...admin|2L......|
|00005ff0| 00 06 01 04 3c 00 00 00 | 11 04 3c 00 00 00 02 0b |....<...|..<.....|
|00006000| 40 20 1f 58 d0 fa c6 88 | 40 f7 ed f9 00 02 bf 4b |@ .X....|@......K|
|00006010| f9 00 09 06 61 64 6d 69 | 6e 32 4c c4 fd 00 01 02 |....admi|n2L.....|
|00006020| ec 00 06 01 04 3c 00 00 | 00 11 04 3c 00 00 00 02 |.....<..|...<....|
|00006030| 02 40 20 fb aa 04 ab 40 | f5 f9 f9 00 02 bf 4b f9 |.@ ....@|......K.|
|00006040| 00 09 06 61 64 6d 69 6e | 32 4c c4 fd 00 01 04 ec |...admin|2L......|
|00006050| 00 06 01 04 3c 00 00 00 | 11 04 3c 00 00 00 02 0c |....<...|..<.....|
|00006060| 40 20 50 d7 94 35 e5 0d | 40 f7 31 80 fa 00 02 bf |@ P..5..|@.1.....|
|00006070| 4b f9 00 09 06 61 64 6d | 69 6e 32 4c c4 fd 00 01 |K....adm|in2L....|
|00006080| 05 ec 00 06 01 04 3c 00 | 00 00 11 04 3c 00 00 00 |......<.|....<...|
|00006090| 02 02 40 1e fa 00 03 40 | f1 17 f9 00 02 bf 4b f9 |..@....@|......K.|
|000060a0| 00 09 06 61 64 6d 69 6e | 32 4c c4 fd 00 01 0b ec |...admin|2L......|
|000060b0| 00 06 01 04 3c 00 00 00 | 11 04 3c 00 00 00 02 02 |....<...|..<.....|
|000060c0| 40 1e fa 00 03 40 e7 70 | f9 00 02 bf 4b f9 00 09 |@....@.p|....K...|
|000060d0| 06 61 64 6d 69 6e 32 4c | c4 fd 00 01 0c ec 00 06 |.admin2L|........|
|000060e0| 01 04 3c 00 00 00 11 04 | 3c 00 00 00 02 02 40 1e |..<.....|<.....@.|
|000060f0| fa 00 03 40 ee 46 f9 00 | 02 bf 4b f9 00 09 06 61 |...@.F..|..K....a|
|00006100| 64 6d 69 6e 32 4c c4 fd | 00 01 0e ec 00 06 01 04 |dmin2L..|........|
|00006110| 3c 00 00 00 11 04 3c 00 | 00 00 02 02 40 1e fa 00 |<.....<.|....@...|
|00006120| 03 40 ed 4c f9 00 02 bf | 4b f9 00 09 06 61 64 6d |.@.L....|K....adm|
|00006130| 69 6e 32 4c c4 fd 00 01 | 0f ec 00 06 01 04 3c 00 |in2L....|......<.|
|00006140| 00 00 11 04 3c 00 00 00 | 02 02 40 1e fa 00 03 40 |....<...|..@....@|
|00006150| f3 88 f9 00 02 bf 4b f9 | 00 09 06 61 64 6d 69 6e |......K.|...admin|
|00006160| 32 4c c4 fd 00 01 14 ec | 00 06 01 04 3c 00 00 00 |2L......|....<...|
|00006170| 11 04 3c 00 00 00 02 02 | 40 1e fa 00 04 40 f1 d2 |..<.....|@....@..|
|00006180| 80 fa 00 02 bf 4b f9 00 | 09 06 61 64 6d 69 6e 32 |.....K..|..admin2|
|00006190| 4c c4 fd 00 01 18 ec 00 | 06 01 04 3c 00 00 00 11 |L.......|...<....|
|000061a0| 04 3c 00 00 00 02 02 40 | 1e fa 00 03 40 ee 46 f9 |.<.....@|....@.F.|
|000061b0| 00 02 bf 4b f9 00 09 06 | 61 64 6d 69 6e 32 4c c4 |...K....|admin2L.|
|000061c0| fd 00 01 1d ec 00 06 01 | 04 3c 00 00 00 11 04 3c |........|.<.....<|
|000061d0| 00 00 00 02 02 40 1e fa | 00 03 40 ea db f9 00 02 |.....@..|..@.....|
|000061e0| bf 4b f9 00 09 06 61 64 | 6d 69 6e 32 4c c4 fd 00 |.K....ad|min2L...|
|000061f0| 01 22 ec 00 06 01 04 3c | 00 00 00 11 04 3c 00 00 |.".....<|.....<..|
|00006200| 00 02 02 40 1e fa 00 03 | 40 dd 4c f9 00 02 bf 4b |...@....|@.L....K|
|00006210| f9 00 09 06 61 64 6d 69 | 6e 32 4c c4 fd 00 01 24 |....admi|n2L....$|
|00006220| ec 00 06 01 04 3c 00 00 | 00 11 04 3c 00 00 00 02 |.....<..|...<....|
|00006230| 02 40 1e fa 00 03 40 e1 | 17 f9 00 02 bf 4b f9 00 |.@....@.|.....K..|
|00006240| 09 06 61 64 6d 69 6e 32 | 4c c4 fd 00 01 25 ec 00 |..admin2|L....%..|
|00006250| 06 01 04 3c 00 00 00 11 | 04 3c 00 00 00 02 02 40 |...<....|.<.....@|
|00006260| 1e fa 00 03 40 e8 6a f9 | 00 02 bf 4b f9 00 09 06 |....@.j.|...K....|
|00006270| 61 64 6d 69 6e 32 4c c4 | fd 00 01 2c ec 00 06 01 |admin2L.|...,....|
|00006280| 04 3c 00 00 00 11 04 3c | 00 00 00 02 02 40 1e fa |.<.....<|.....@..|
|00006290| 00 03 40 f1 94 f9 00 02 | bf 4b f9 00 09 06 61 64 |..@.....|.K....ad|
|000062a0| 6d 69 6e 32 4c c4 fd 00 | 01 2d ec 00 06 01 04 3c |min2L...|.-.....<|
|000062b0| 00 00 00 11 04 3c 00 00 | 00 02 02 40 11 fa 00 03 |.....<..|...@....|
|000062c0| 40 ee 46 f9 00 02 c0 56 | f9 00 09 06 65 6c 61 69 |@.F....V|....elai|
|000062d0| 6e 65 4c c4 fd 00 01 08 | ec 00 06 01 04 3c 00 00 |neL.....|.....<..|
|000062e0| 00 11 04 3c 00 00 00 02 | 02 40 11 fa 00 03 40 f1 |...<....|.@....@.|
|000062f0| 94 f9 00 02 c0 56 f9 00 | 09 06 65 6c 61 69 6e 65 |.....V..|..elaine|
|00006300| 4c c4 fd 00 01 09 ec 00 | 06 01 04 3c 00 00 00 11 |L.......|...<....|
|00006310| 04 3c 00 00 00 02 02 40 | 11 fa 00 04 40 f2 5f 20 |.<.....@|....@._ |
|00006320| fa 00 02 c0 56 f9 00 09 | 06 65 6c 61 69 6e 65 4c |....V...|.elaineL|
|00006330| c4 fd 00 01 0b ec 00 06 | 01 04 3c 00 00 00 11 04 |........|..<.....|
|00006340| 3c 00 00 00 02 02 40 11 | fa 00 03 40 e9 32 f9 00 |<.....@.|...@.2..|
|00006350| 02 c0 56 f9 00 09 06 65 | 6c 61 69 6e 65 4c c4 fd |..V....e|laineL..|
|00006360| 00 01 0c ec 00 06 01 04 | 3c 00 00 00 11 04 3c 00 |........|<.....<.|
|00006370| 00 00 02 02 40 11 fa 00 | 04 40 f0 45 a0 fa 00 02 |....@...|.@.E....|
|00006380| c0 56 f9 00 09 06 65 6c | 61 69 6e 65 4c c4 fd 00 |.V....el|aineL...|
|00006390| 01 0e ec 00 06 01 04 3c | 00 00 00 11 04 3c 00 00 |.......<|.....<..|
|000063a0| 00 02 02 40 11 fa 00 04 | 40 ef 7e 80 fa 00 02 c0 |...@....|@.~.....|
|000063b0| 56 f9 00 09 06 65 6c 61 | 69 6e 65 4c c4 fd 00 01 |V....ela|ineL....|
|000063c0| 0f ec 00 06 01 04 3c 00 | 00 00 11 04 3c 00 00 00 |......<.|....<...|
|000063d0| 02 02 40 11 fa 00 03 40 | f4 ff f9 00 02 c0 56 f9 |..@....@|......V.|
|000063e0| 00 09 06 65 6c 61 69 6e | 65 4c c4 fd 00 01 14 ec |...elain|eL......|
|000063f0| 00 06 01 04 3c 00 00 00 | 11 04 3c 00 00 00 02 02 |....<...|..<.....|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.